On 06/19/2012 09:08 PM, Raghavendra wrote: > How can we figure out no. of commit/rollback happend on the database > by application ? >
If am a DBA, how to know exact application or user commits/rollbacks happened on the database without enabling logs.
This sounds like one of those "what are you trying to achieve" questions, where you need to step back and ask why you're trying to collect that info and what you want it for.
First, how do you define "application"? Any client that connects to a given database? Any client that sets the application_name GUC to a particular value? Any client from a given host? etc. "Application" can mean a lot of different things. It sounds like you might simply mean work done on a connection that isn't internal to the database system's bookkeeping, which is a bit easier, but I'm not sure.
Second, why? What does the transaction count tell you? How will you account for work done by PgAgent (if used), via dblink, etc?
I guess I'm unsure what you're trying to accomplish. -- Craig Ringer -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
