# Query log showing different rows\_sent for same query
**URL:** https://forums.percona.com/t/query-log-showing-different-rows-sent-for-same-query/10110
**Category:** ProxySQL
**Created:** [April 15, 2021, 2:46pm UTC](https://forums.percona.com/t/query-log-showing-different-rows-sent-for-same-query/10110 "2021-04-15T14:46:19Z")
**Posts on this page:** 2
**Page:** 1
### Author:  [@star2star\_lewis](https://forums.percona.com/u/star2star_lewis)
#### Post date: [April 15, 2021, 2:46pm UTC](https://forums.percona.com/t/query-log-showing-different-rows-sent-for-same-query/10110/1 "2021-04-15T14:46:19Z")
I am running the same query on the same hostgroup and getting a different number in rows\_sent. They should be the same. Direct query on the database returns 22 rows. Query is shortened, but it is the same.
---
### Author:  [@star2star\_lewis](https://forums.percona.com/u/star2star_lewis)
#### Post date: [April 15, 2021, 2:46pm UTC](https://forums.percona.com/t/query-log-showing-different-rows-sent-for-same-query/10110/2 "2021-04-15T14:46:36Z")
{
“client”: “10.32.146.239:38208”,
“digest”: “0xB42FB28B1E283AFE”,
“duration\_us”: 1510,
“endtime”: “2021-04-15 14:31:28.709285”,
“endtime\_timestamp\_us”: 1618497088709285,
“event”: “COM\_QUERY”,
“hostgroup\_id”: 10,
“query”: "select p.\* from db1.api\_permissions p INNER JOIN db1.api\_systems s ON(s.id = p.api\_key\_id) WHERE s.apikey …
“rows\_affected”: 0,
**“rows\_sent”: 22,**
“schemaname”: “information\_schema”,
“server”: “db1-aws:3306”,
“starttime”: “2021-04-15 14:31:28.707775”,
“starttime\_timestamp\_us”: 1618497088707775,
“thread\_id”: 17383674,
“username”: “oauth”
}
{
“client”: “10.32.140.33:60162”,
“digest”: “0xB42FB28B1E283AFE”,
“duration\_us”: 1419,
“endtime”: “2021-04-15 14:31:29.703582”,
“endtime\_timestamp\_us”: 1618497089703582,
“event”: “COM\_QUERY”,
“hostgroup\_id”: 10,
“query”: "select p.\* from db1.api\_permissions p INNER JOIN db1.api\_systems s ON(s.id = p.api\_key\_id) WHERE s.apikey …
“rows\_affected”: 0,
**“rows\_sent”: 12,**
“schemaname”: “information\_schema”,
“server”: “db1-aws:3306”,
“starttime”: “2021-04-15 14:31:29.702163”,
“starttime\_timestamp\_us”: 1618497089702163,
“thread\_id”: 17390171,
“username”: “oauth”
}