# View: dt_prod_ows_warehouse_monitoring

**View Name:** dt_prod_ows_warehouse_monitoring
**Table Source:** `Derived from: Account_Usage.Query_History, Snowflake.Account_Usage`
**File Path:** `dt_prod_ows_warehouse_monitoring.view.lkml`

## Overview

- **File Size:** 1378 bytes
- **Lines of Code:** 59
- **Dimensions:** 1
- **Measures:** 5
- **Dimension Groups:** 0
- **Filters:** 0

## Comments & Notes

- of Queries"
- of Queries > 15s"
- of Queries > 60s"

## Dimensions

| Name | Type |
|------|------|
| `start_time` | date |

## Measures

| Name | Type |
|------|------|
| `count_queries` | sum |
| `count_queries_slower_15` | sum |
| `percent_queries_slower_15` | sum |
| `count_queries_slower_60` | sum |
| `percent_queries_slower_60` | sum |

## Derived Table

```sql
sql:
SELECT
    date(start_time) AS start_time,
    COUNT(*) as queries,
    SUM(IFF(total_elapsed_time > 15000,1,0)) AS slower_than_15,
    SUM(IFF(total_elapsed_time > 15000,1,0))/count(*) * 100 AS per_slower_than_15,
    SUM(IFF(total_elapsed_time > 60000,1,0)) AS slower_than_60,
    SUM(IFF(total_elapsed_time > 60000,1,0))/count(*) * 100 AS per_slower_than_60
FROM snowflake.account_usage.query_history
WHERE warehouse_name = 'PROD_OWS_WAREHOUSE'
AND query_type = 'SELECT'
AND start_time >= '2020-02-01'
AND user_name = 'PROD_VAPI'
GROUP BY 1
ORDER BY 1
  ;;
```