Blocking Alert
Blocking Alert
От:
"Anjul Tyagi" <anjul@ibosstech-us.com>
Дата:
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
Re: Blocking Alert
От:
Shreeyansh Dba <shreeyansh2014@gmail.com>
Дата:
On Mon, Oct 1, 2018 at 11:32 AM Anjul Tyagi <anjul@ibosstech-us.com> wrote:
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
Re: Blocking Alert
От:
"Anjul Tyagi" <anjul@ibosstech-us.com>
Дата:
Shreeyansh,
that will be an overhead for the database, can we get information via query ?
Regards,
Anjul TYAGI
ü Go Green
------ Original Message ------
From: "Shreeyansh Dba" <shreeyansh2014@gmail.com>
To: "Anjul Tyagi" <anjul@ibosstech-us.com>
Cc: "pgsql-admin" <pgsql-admin@postgresql.org>
Sent: 01-10-2018 15:30:48
Subject: Re: Blocking Alert
On Mon, Oct 1, 2018 at 11:32 AM Anjul Tyagi <anjul@ibosstech-us.com> wrote: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