Re: Profiling a function call

ne 21. 5. 2023 v 13:30 odesílatel Jan Wieck <jan(at)wi3ck(dot)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

https://github.com/okbob/plpgsql_check#tracer

Regards

Pavel

>
>
>
> Best Regards, Jan
>
> >
> > PostgreSQL 15.2 on Linux.
> >
> > Thanks.
> >
> > Tiff
>
>
>
>