Postgres Pro
Downloads
Home   >   mailing lists

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

From James Pang
Subject how to trace a backend session
Date
Msg-id CAHgTRfdxpArQcJ1hx7vVLHWaCjyyYNSDdOAH7gbg5rq9+r7pUg@mail.gmail.com
Whole thread Raw
Responses Re: how to trace a backend session
List pgsql-general
Tree view
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: Chris Angelico
Date:
Subject: Re: Logical replication claims to work, not working - new tables
Next
From: Amit Sharma
Date:
Subject: Disk Groups/Storage Management for a Large Database in PostgreSQL