Re: how to trace a backend session

2024-01-24 Thread Dominique Devienne
> > Le lun. 22 janv. 2024 à 08:29, James Pang a > écrit : > >> [...] 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. >> > On Tu

Re: how to trace a backend session

2024-01-23 Thread Pierre Forstmann
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 a écrit : > experts, > We migrated our