| From: | "Anjul Tyagi" <anjul(at)ibosstech-us(dot)com> |
|---|---|
| To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Blocking Alert |
| Date: | 2018-10-01 06:02:25 |
| Message-ID: | em8a51f507-acad-493c-9420-3931662d49ee@iboss01081 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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)
Regards,
Anjul TYAGI
ü Go Green
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shreeyansh Dba | 2018-10-01 10:00:48 | Re: Blocking Alert |
| Previous Message | David G. Johnston | 2018-09-30 17:19:19 | Re: Owner of schema cant access foreign tables in that schema |