Profiling a function call

From: Tiffany Thang <tiffanythang(at)gmail(dot)com>
To: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Profiling a function call
Date: 2023-05-20 04:36:27
Message-ID: CAB_W-NNUBTh4t8TPzb05jb+3d0s4ijPqh8h1odqeY=gAqXjwxA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Julien Rouhaud 2023-05-20 04:57:08 Re: Trying to understand a failed upgrade in AWS RDS
Previous Message Mike Lissner 2023-05-19 21:56:34 Re: Trying to understand a failed upgrade in AWS RDS