When I go to APM > Applications > PHP Application > Databases it shows the list of queries and their performance. But the queries are shown like <table name> select. How can I see the full query?
Advertisement
Answer
According to https://docs.newrelic.com/docs/agents/nodejs-agent/installation-configuration/nodejs-agent-configuration#tx_tracer_config you have to set the record_sql configuration to either 'raw' or 'obfuscated'. By default it is 'off' so you won’t see the SQL.
Keep in mind that this is in the transaction_tracer sections. So for Node.js for instance (I know you’re using PHP), you would do:
{
transaction_tracer: {
record_sql: 'raw',
},
}