You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Summary:
Slow queries is currently not displaying all queries on k8s universe pods. The reason is
due to the database only storing pg_stat_statements on the node which received the queries.
Currently we fetch queries from the first node/pod in the list, so let's fetch from all nodes and
aggregate the results. This issue should also be apparently on multi-node clusters or when queries
are run against read replicas.
**Note: I haven't tested it locally yet due to being unable to create universes, so it would be helpful to hear opinions on whether this is the best way to go about it.**
Test Plan:
Create multi-node (or k8s) universe and run queries on different nodes and check that YW displays the
information correctly. Confirm that queries on read replicas also show up.
Reviewers: arnav, wesley, sb-yb, spotachev
Reviewed By: spotachev
Subscribers: jenkins-bot, yugaware
Differential Revision: https://phabricator.dev.yugabyte.com/D11114
YintongMa
pushed a commit
to YintongMa/yugabyte-db
that referenced
this issue
May 26, 2021
…pod.
Summary:
Slow queries is currently not displaying all queries on k8s universe pods. The reason is
due to the database only storing pg_stat_statements on the node which received the queries.
Currently we fetch queries from the first node/pod in the list, so let's fetch from all nodes and
aggregate the results. This issue should also be apparently on multi-node clusters or when queries
are run against read replicas.
**Note: I haven't tested it locally yet due to being unable to create universes, so it would be helpful to hear opinions on whether this is the best way to go about it.**
Test Plan:
Create multi-node (or k8s) universe and run queries on different nodes and check that YW displays the
information correctly. Confirm that queries on read replicas also show up.
Reviewers: arnav, wesley, sb-yb, spotachev
Reviewed By: spotachev
Subscribers: jenkins-bot, yugaware
Differential Revision: https://phabricator.dev.yugabyte.com/D11114
Slow queries doesn't show any ysql queries running on k8s pods.
The text was updated successfully, but these errors were encountered: