Обсуждение: Profiling a function call
Hi,
I have a function that has been executing for a long time and not returning any results. Wait event=NULL so it seems like it is still executing and not waiting on any specific resources. Is there a way to profile the function call to get an idea of what it is currently executing within the function? All I could find in pg_stat_activity is the function is running. I want to know what query/transaction within the function is running. Is there a way to obtain that information?
PostgreSQL 15.2 on Linux.
Thanks.
Tiff
On 5/20/23 00:36, Tiffany Thang wrote: > Hi, > I have a function that has been executing for a long time and not > returning any results. Wait event=NULL so it seems like it is still > executing and not waiting on any specific resources. Is there a way to > profile the function call to get an idea of what it is currently > executing within the function? All I could find in pg_stat_activity is > the function is running. I want to know what query/transaction within > the function is running. Is there a way to obtain that information? This may give you some idea. I haven't touched or used it in many years, but it might get you started: https://github.com/wieck/plbacktrace Best Regards, Jan > > PostgreSQL 15.2 on Linux. > > Thanks. > > Tiff
ne 21. 5. 2023 v 13:30 odesílatel Jan Wieck <jan@wi3ck.info> napsal:
On 5/20/23 00:36, Tiffany Thang wrote:
> Hi,
> I have a function that has been executing for a long time and not
> returning any results. Wait event=NULL so it seems like it is still
> executing and not waiting on any specific resources. Is there a way to
> profile the function call to get an idea of what it is currently
> executing within the function? All I could find in pg_stat_activity is
> the function is running. I want to know what query/transaction within
> the function is running. Is there a way to obtain that information?
This may give you some idea. I haven't touched or used it in many years,
but it might get you started:
https://github.com/wieck/plbacktrace
plpgsql_check has integrated tracer
Regards
Pavel
Best Regards, Jan
>
> PostgreSQL 15.2 on Linux.
>
> Thanks.
>
> Tiff
Thanks, Jan and Pavel. I will check out the tracer.
Tiff
On Sun, May 21, 2023 at 7:43 AM Pavel Stehule <pavel.stehule@gmail.com> wrote:
ne 21. 5. 2023 v 13:30 odesílatel Jan Wieck <jan@wi3ck.info> napsal:On 5/20/23 00:36, Tiffany Thang wrote:
> Hi,
> I have a function that has been executing for a long time and not
> returning any results. Wait event=NULL so it seems like it is still
> executing and not waiting on any specific resources. Is there a way to
> profile the function call to get an idea of what it is currently
> executing within the function? All I could find in pg_stat_activity is
> the function is running. I want to know what query/transaction within
> the function is running. Is there a way to obtain that information?
This may give you some idea. I haven't touched or used it in many years,
but it might get you started:
https://github.com/wieck/plbacktraceplpgsql_check has integrated tracerRegardsPavel
Best Regards, Jan
>
> PostgreSQL 15.2 on Linux.
>
> Thanks.
>
> Tiff