Re: How to get no. of commits/rollbacks by application on the database?

> 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.
>
>
Thanks Craig for your reply.
4 What's, 2 Why's, 2 How's ... :)

Let me put my question simple.

What counts include in xact_commit & xact_rollback of pg_stat_database ?

--Raghav