Postgres Pro
Downloads
Home   >   mailing lists

Re: how to trace a backend session - Mailing list pgsql-general

From Pierre Forstmann
Subject Re: how to trace a backend session
Date
Msg-id CAM-sOH9qm8Ah4cs-i7-EVBB0bbdEm408hy0OmnEmK6880H-0UA@mail.gmail.com
Whole thread Raw
In response to how to trace a backend session  (James Pang <jamespang886@gmail.com>)
Responses Re: how to trace a backend session  (Dominique Devienne <ddevienne@gmail.com>)
List pgsql-general
Tree view
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@gmail.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 

pgsql-general by date:

Previous
From: Sasmit Utkarsh
Date:
Subject: Need assistance for running postgresql procedures
Next
From: Francisco Olarte
Date:
Subject: Re: Need assistance for running postgresql procedures