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

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