APM transaction for Postgres only showing Begin and Commit statements, why I can't I see the statements in between?

All of my transactions that include sql queries are only showing the begin and commit messages.... Is it supposed to display the actual commands that were executed in between?

Hi and welcome to the forum :wave:

Could you share which agent, which version, and which database driver you are using?

Thanks,
Felix

Thank you:)

I am using the apm-server:7.7.0 helm release, along with elasticsearch helm 7.7.0 and the apm agent in nodejs: "elastic-apm-node": "^3.6.1" with Postgres v11.6

Did you already add pg_state_activity and pg_stat_statement?

Perhaps you need to view this URL, that similar to use APM:

https://docs.appdynamics.com/display/PRO45/Configure+PostgreSQL+Collectors

Regards,
Fadjar Tandabawana

Hmmm so my elastic and applications are running on Kubernetes but my database instance is running on AWS RDS, not sure I'd be able to add those to AWS RDS? Where would this collector be added for elastic apm deployed via helm to kubernetes?

Please check this if you need to check the pg_stat_activity or pg_stat_statement:
https://pganalyze.com/docs/install/amazon_rds/01_configure_rds_instance