Profiling a function call

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

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

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

Regards

Pavel

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: