# \[QAN\] Add user & source on query details

**URL:** <https://forums.percona.com/t/qan-add-user-source-on-query-details/6753>\
**Category:** PMM 1.x\
**Created:** [December 20, 2018, 4:47am UTC](https://forums.percona.com/t/qan-add-user-source-on-query-details/6753 "2018-12-20T04:47:07Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rlelievre](https://avatars.discourse-cdn.com/v4/letter/r/34f0e0/32.png) [@Rlelievre](https://forums.percona.com/u/Rlelievre)\
**Post date:** [December 20, 2018, 4:47am UTC](https://forums.percona.com/t/qan-add-user-source-on-query-details/6753/1 "2018-12-20T04:47:07Z")

</div>

Hi,

I’ve setup PMM for some MySQL production server. It work like a charm even on a little server (RAM 5Go, Debian 7). Congrats for this beautiful tool !  
Ugrade is already planified, when I will migrate on a new VM.

For now, I would know if it is possible on QAN to obtain for each query the user and/or source who executed it ?  
I’ven’t seen any options to add it for now.

We have many applications that connect on central servers, each with different users. Queries on the same table may come from several source.  
Having this information available would allow us to have a better view of the source of slowness.

Is this an already planned improvement ?

---

<div class="post-metadata">

**Author:** ![Michael\_Coburn](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/michael_coburn/32/18_2.png) [@Michael\_Coburn](https://forums.percona.com/u/Michael_Coburn)\
**Post date:** [February 4, 2019, 2:44pm UTC](https://forums.percona.com/t/qan-add-user-source-on-query-details/6753/2 "2019-02-04T14:44:59Z")

</div>

Hi [Rlelievre](https://percona.vanillacommunities.com/profile/x/x/42532)

I’m glad to hear you’re enjoying PMM!

In PMM Server 1.x you cannot see the user nor source for Query Analytics. We are introducing support for this type of view in our PMM 2.0 release, which we are expecting an alpha to ship towards the end of this month! So yes this is an improvement that is planned 🙂

---

<div class="post-metadata">

**Author:** ![Rlelievre](https://avatars.discourse-cdn.com/v4/letter/r/34f0e0/32.png) [@Rlelievre](https://forums.percona.com/u/Rlelievre)\
**Post date:** [February 5, 2019, 10:31am UTC](https://forums.percona.com/t/qan-add-user-source-on-query-details/6753/3 "2019-02-05T10:31:28Z")

</div>

Hi Michael,

That’s exactly the kind of answer I was hoping ! Perfect ! Looking forward for testing it.

Thanks,

---

<div class="post-metadata">

**Author:** ![Michael\_Coburn](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/michael_coburn/32/18_2.png) [@Michael\_Coburn](https://forums.percona.com/u/Michael_Coburn)\
**Post date:** [February 6, 2019, 11:41am UTC](https://forums.percona.com/t/qan-add-user-source-on-query-details/6753/4 "2019-02-06T11:41:04Z")

</div>

You’re welcome [Rlelievre](https://percona.vanillacommunities.com/profile/x/x/42532) ! Keep your eye on [Database Performance Blog – Percona](http://percona.com/blog) as that will be the place we announce the PMM 2.0 alpha availability! All the best,