# How to find out which source writes the most to the historian database

**URL:** <https://forum.inductiveautomation.com/t/how-to-find-out-which-source-writes-the-most-to-the-historian-database/74628>\
**Category:** Ignition\
**Tags:** ignition81\
**Created:** [June 6, 2023, 12:18pm UTC](https://forum.inductiveautomation.com/t/how-to-find-out-which-source-writes-the-most-to-the-historian-database/74628 "2023-06-06T12:18:25Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![hewking32](https://avatars.discourse-cdn.com/v4/letter/h/b5ac83/32.png) [@hewking32](https://forum.inductiveautomation.com/u/hewking32)\
**Post date:** [June 6, 2023, 12:18pm UTC](https://forum.inductiveautomation.com/t/how-to-find-out-which-source-writes-the-most-to-the-historian-database/74628/1 "2023-06-06T12:18:25Z")

</div>

hi All  
How would you check which source of historic data writes the most of data volume to the historian database? Gateway status provides info about the traffic which is mostly Select queries not inserts.  
This finding would be later used to decrease the volume by optimising the frequency etc.

Regards

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [June 6, 2023, 12:43pm UTC](https://forum.inductiveautomation.com/t/how-to-find-out-which-source-writes-the-most-to-the-historian-database/74628/2 "2023-06-06T12:43:56Z")

</div>

Do a select against a partition table grouping by tag id and delivering the row count. Join that against the meta-data to get the tag path.