Reference for Database Query Performance

Reference material for using Database Query Performance in Splunk APM.

Supported databases

Database Query Performance provides insights for the following database software:

  • Amazon Redshift

  • Db2

  • Google Cloud Spanner

  • MariaDB

  • Microsoft SQL Server

  • MySQL

  • OceanBase

  • Oracle

  • PostgreSQL

  • Presto

  • Redis

Database Query Performance works with all versions supported by the instrumented applications.

Note: Related Content is available for Oracle, MySQL, Redis, and Microsoft SQL Server. For more information on related content, see Related Content in Splunk Observability Cloud.

Database Query Performance indexes the following span tags. These attributes are aligned to the most recent OpenTelemetry semantic conventions. Starting with OpenTelemetry version 1.33.0, database system conventions were standardized, and Splunk APM automatically maps any outdated semantic conventions in your instrumentation library to the latest conventions, ensuring data consistency. For example, db.name will automatically map to db.namespace in Splunk APM.

For more information, see Semantic conventions for database calls and systems in the OpenTelemetry GitHub repo.

SQL databases

Key

Type

Description

Normalized db.statement (_sf_normalized_db_statement)

string

The database statement, with dynamic elements replaced with placeholders to reduce cardinality

db.namespace

string

Name of the database

db.type

string

Type of database
Note: This span tag has been removed.

db.operation.name

string

Operation in the database

db.sql.table

string

Table in the database (SQL only)

db.system.name

string

System of the database

Redis

Key

Type

Description

Database operation (_sf_db_operation)

string

Operation in the database, derived from db.statement or db.operation

db.system

string

System of the database

Learn more

See the following links for more information about Database Query Performance: