---
sourceDocument: Yokohama Platform security
sourceDocumentLink: https://www.servicenow.com/docs/r/yokohama/platform-security

 Release :

    - yokohama

ft:locale :

    - en-US

ft:publication_title :

    - Yokohama Platform security

ft:clusterId :

    - psec

bundleId :

    - psec

workflow :

    - Platform


---

# Security data filter performance analysis tool

# Security data filter performance analysis tool {#ariaid-title1}

Release version: Yokohama  
Updated March 6, 2025  
![](https://www.servicenow.com/docs/portal-asset/ico-clock) 2 minutes to read  
The security data filter performance analysis tool identifies performance bottlenecks introduced by a security data filter.

## Before you begin

Role required: security_admin

## About this task

The performance analysis tool provides feedback on performance impact of a security data filter. It analyzes the query execution when the specified data filter is applied to the table, alongside any encoded query provided for
analysis. This identifies potential performance bottlenecks introduced by the new data filter, enabling informed decision-making to balance security requirements with optimal query performance.

## Procedure

1. In the navigation filter, enter sys_properties.list.
2. Set the property glide.security.data_filter.diagnostic_enabled to true.  
   If the property does not exist in the System Properties table, read [Add a system property](https://www.servicenow.com/docs/access?context=t_AddAPropertyUsingSysPropsList&version=yokohama&pubname=yokohama-platform-administration&ft:locale=en-US) and add the property manually.
3. Navigate to AllSystem SecuritySecurity Data Filters.
4. Select a security data filter to analyze.
5. Select Analyze Performance under Related Links.
6. In the form, fill in the fields as needed.  
   {#security-data-filter-performance-analysis-tool__table_o2q_yyz_42c__entry__2}

   | Field | Description |
   |-|-|
   | Data Filter | The selected data filter for analysis |
   | Related active data filters | The number of currently active data filters that may impact performance. Select the information icon (![information icon]()) to view the active data filters. |
   | Table | The selected table for analysis. |
   | Encoded query | The query for analysis. |
   | Query runs | The number of times to sample the query performance. Note: Must be between 10-100. |
   [Table 1. Analyze Performance form]

   {#security-data-filter-performance-analysis-tool__table_o2q_yyz_42c}
7. Select Analyze query performance.
{#security-data-filter-performance-analysis-tool__steps_bd1_cqz_42c}

## Result

The Performance Summary section compares the execution of the query times with and without the selected data filter applied. It captures various metrics including Max, Min, Mean, and
Median query execution times and provides a comprehensive analysis of the filter's impact on performance.  
The performance impact indicator provides high level guidance to filter performance. The indicator results are calculated from the median change in query execution time. The query execution time often correlates to the complexity of both the filter and user query. See the [security-data-filters.html#security-data-filters__section_fyq_jkd_p2c](https://www.servicenow.com/docs/u5UdzvknUtSGK5YOn3iIqA#security-data-filters__section_fyq_jkd_p2c) for more information on security data filter performance.{#security-data-filter-performance-analysis-tool__table_c4h_wsz_42c__entry__3}

| Indicator | Message | Explanation |
|-|-|-|
| Low | This data filter doesn't slow down queries or page load times. | The percentage change in the median query execution time is 0% (no change). |
| Medium | This data filter can slow down existing queries and make pages take longer to load. | The percentage change in the median query execution time is greater than 0% and up to 100%. |
| Critical | This data filter takes longer to run. This slows down existing queries and makes pages take longer to load. | The percentage change in the median query execution time is greater than 100%. |
[Table 2. Performance impact indicators]

{#security-data-filter-performance-analysis-tool__table_c4h_wsz_42c}

*[\>]: and then