Profiling a function call - Mailing list pgsql-general

From Tiffany Thang
Subject Profiling a function call
Date
Msg-id CAB_W-NNUBTh4t8TPzb05jb+3d0s4ijPqh8h1odqeY=gAqXjwxA@mail.gmail.com
Whole thread Raw
Responses Re: Profiling a function call  (Jan Wieck <jan@wi3ck.info>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Mike Lissner
Date:
Subject: Re: Trying to understand a failed upgrade in AWS RDS
Next
From: Julien Rouhaud
Date:
Subject: Re: Trying to understand a failed upgrade in AWS RDS