>
> 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
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
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
