# User Session Query Language - example

**URL:** <https://community.dynatrace.com/t/user-session-query-language-example/19564>\
**Category:** Real User Monitoring\
**Tags:** usql\
**Created:** [February 14, 2019, 7:29am UTC](https://community.dynatrace.com/t/user-session-query-language-example/19564 "2019-02-14T07:29:31Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![David\_Hauger](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/david_hauger/32/13595_2.png) [@David\_Hauger](https://community.dynatrace.com/u/David_Hauger)\
**Post date:** [February 14, 2019, 8:20am UTC](https://community.dynatrace.com/t/user-session-query-language-example/19564/2 "2019-02-14T08:20:56Z")

</div>

You could use:

```auto
SELECT starttime, visuallyCompleteTime FROM useraction WHERE name = "name" AND usersession.userId = "test@test"

```

to get all the different values.

Or, if they are too much:

```auto
SELECT AVG(visuallyCompleteTime), MIN(visuallyCompleteTime), MAX(visuallyCompleteTime), COUNT(*) FROM useraction WHERE name = "name" AND usersession.userId = "test@test"

```

to get some statistics on the visuallyCompleteTime

---

_[View the full topic](https://community.dynatrace.com/t/user-session-query-language-example/19564)._
