In SQLServer when now we have purposes for which we wouldn’t have supply code we may use SQLServer profiler to investigate which queries or procedures are referred to as once we do one thing in app. Now I’ve related state of affairs with .NET third get together library and postgre database when it will be very helpful to trace queries referred to as by that library. I discovered one thing related in pgAdmin, however to date I do know it seem to by helpful to trace solely sql queries which can be executed in pgAdmin, not queries from exterior purposes. I am not very fluent in postgre, as a result of that is my first contact with this surroundings.
So to sum up: Is there a device that permit me to trace queries executed on postgre database from exterior purposes?
EDIT: I attempted to pick out from pg_stat_activity, however once I anticipate to see which saved procedures or sql is executed it prints solely “COMMIT” string in “question” column