Re: Correct query for monitor

2025-09-26 Thread Laurenz Albe
On Sat, 2025-09-27 at 01:45 +0530, veem v wrote: > If we want to identify, what exact query inside a procedure is taking a > longer time: > - Using any pg_* views, Is there an easy way to tie the query_id of the > procedure > with the query_ids of the internal sqls(those are executed within the

Re: Correct query for monitor

2025-09-26 Thread Ron Johnson
On Fri, Sep 26, 2025 at 4:15 PM veem v wrote: > Thank you so much for the quick response. I have a follow up question on > this as below, > > If we want to identify, what exact query inside a procedure is taking a > longer time:- Using any pg_* views, Is there an easy way to tie the > query_id of

Re: Correct query for monitor

2025-09-26 Thread veem v
Thank you so much for the quick response. I have a follow up question on this as below, If we want to identify, what exact query inside a procedure is taking a longer time:- Using any pg_* views, Is there an easy way to tie the query_id of the procedure with the query_ids of the internal sqls(thos