AppDynamics Knowledge Base

How to capture queries from Postgres database in a snapshot

How to capture queries from Postgres database in a snapshot

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
Labels (1)
Comments

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.

Hi @Pandiyan.Gunasekaran,

 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

Version history
Last update:
‎07-11-2017 03:25 PM
Updated by: