Re: how to trace a backend session

From: Pierre Forstmann <pierre(dot)forstmann(at)gmail(dot)com>
To: James Pang <jamespang886(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: how to trace a backend session
Date: 2024-01-23 18:45:05
Message-ID: CAM-sOH9qm8Ah4cs-i7-EVBB0bbdEm408hy0OmnEmK6880H-0UA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I have coded an extension to trace SQL statements for specific backends:
https://github.com/pierreforstmann/pg_log_statements
(only SQL statements are traced - no wait events data is collected).

Pierre

Le lun. 22 janv. 2024 à 08:29, James Pang <jamespang886(at)gmail(dot)com> a écrit :

> experts,
> We migrated our database from Oracle to Postgresql recently, we used
> to turn on Oracle session trace(that will capture all activities, SQL
> statements, waiting, waiting time), to do living troubleshooting. could
> you direct any similar tracing in Postgresql v13 , v14.
>
> Thanks,
>
> James
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Francisco Olarte 2024-01-23 20:28:23 Re: Need assistance for running postgresql procedures
Previous Message Sasmit Utkarsh 2024-01-23 17:51:23 Need assistance for running postgresql procedures