how to trace a backend session

From: James Pang <jamespang886(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: how to trace a backend session
Date: 2024-01-22 07:29:27
Message-ID: CAHgTRfdxpArQcJ1hx7vVLHWaCjyyYNSDdOAH7gbg5rq9+r7pUg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Amit Sharma 2024-01-22 17:43:58 Disk Groups/Storage Management for a Large Database in PostgreSQL
Previous Message Chris Angelico 2024-01-21 19:28:09 Re: Logical replication claims to work, not working - new tables