Skip to content
Advertisement

How to see full query in New Relic

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',
  },
}
User contributions licensed under: CC BY-SA
7 People found this is helpful
Advertisement