Hi Vagelis,
1. You don't need to explicitly disconnect the connection because it uses a connection pool. The connections won't reach maximum of the pool size.
2. You can use OnSqlExecuting event to track all SQL statements executed by Aurelius:
But you can also try to get the execute SQL from Unidac or PostgreSQL, they are more "low-level" log.