public inbox for [email protected]
help / color / mirror / Atom feedFrom: Greg Sabino Mullane <[email protected]>
To: Bandi, Venkataramana - Dell Team <[email protected]>
Cc: [email protected] <[email protected]>
Cc: Kishore, Nanda - Dell Team <[email protected]>
Cc: Alampalli, Kishore <[email protected]>
Subject: Re: Query on Postgres SQL transaction
Date: Fri, 15 Mar 2024 14:36:44 -0400
Message-ID: <CAKAnmmJcMTxoD2ao8z8YXiU-9FspXZc9L+VKGrAYuig8mN3XSQ@mail.gmail.com> (raw)
In-Reply-To: <PH7PR19MB6876D9AB33CFF7160C4097D295282@PH7PR19MB6876.namprd19.prod.outlook.com>
References: <PH7PR19MB6876D9AB33CFF7160C4097D295282@PH7PR19MB6876.namprd19.prod.outlook.com>
That's a very vague question, but you can trace exactly what is happening
by issuing
SET log_statement = 'all';
Ideally at the session level by your application, but can also set it at
the database and user level. If all else fails, set it globally (i.e.
postgresql.conf). Turn it off again as soon as possible, it will make your
logs extremely verbose. But you can track exactly what your application is
doing.
Cheers,
Greg
view thread (2+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected], [email protected]
Subject: Re: Query on Postgres SQL transaction
In-Reply-To: <CAKAnmmJcMTxoD2ao8z8YXiU-9FspXZc9L+VKGrAYuig8mN3XSQ@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox