In order to view the SQL statements in transaction snapshots related to Postgres database, apply the following node properties.
See: How to Add a Registered Node Property
Property: jdbc-connections
Value: org.postgresql.jdbc.PgConnection
Property: jdbc-statements
Value: org.postgresql.jdbc.PgStatement
Property: jdbc-callable-statements
Value: org.postgresql.jdbc.PgCallableStatement
Property: jdbc-prepared-statements
Value: org.postgresql.jdbc.PgPreparedStatement
Hi,
This is pandiyan.
I just configured PostgreSQL database to AppDynamics Controller for Database Visibility.
In collectors i am able to see only the default database data instead of specific required database. How can i set that to see required database calls and queries.
Thank you,
Pandiyan.
Regarding your concern to data-based visibility using DBAgent, we request you log a support ticket to get assistance
How do I submit a Support ticket? An FAQ
Thanks,
Naren