Get the sql of a preparedstatement in span details

Elastic Observability APM
1

**Kibana version **:7.6

**Elasticsearch version **:7.6

APM Server version:7.6

**APM Agent language and version **: go 1.7.2

how can I get the real sql query in span detail

my code :

db, err := apmsql.Open("mysql", dataSourceName)
db.PrepareContext(context,prepareSql).QueryRowContext(context,args...).scan(dest...)

kibana apm trace mysql span details

select  *   from call_staff where id = ?

I want the real Sql like

select  *   from call_staff where id = 1
2

Hi @yangfeng, welcome to the forum!

We do not capture bind variables by design, as they might contain sensitive information (passwords, credit card numbers, etc.)

There is an open issue for discussing this feature, which we would want to align across the different agents: https://github.com/elastic/apm/issues/220. I suggest adding a :+1: to the issue, and subscribing for updates.

3

ok.thank you