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
