Newrelic + sqlalchemy

Question

如何在newrelic监控中通过sqlalchemy打开postgres查询的跟踪？

我有一个带有sqlalchemy ORM的应用程序，并向其中添加了newrelic，但newrelic不能通过ORM捕获sql查询。

Answer 1

在我的例子中，all start可以在newrelic.ini中使用transaction_tracer.record_sql = raw，但不幸的是，obfuscated出现了问题

# When the transaction tracer is on, SQL statements can
# optionally be recorded. The recorder has three modes, "off"
# which sends no SQL, "raw" which sends the SQL statement in its
# original form, and "obfuscated", which strips out numeric and
# string literals.
transaction_tracer.record_sql = raw