With YCQL, we see below metrics for local reads and remote reads. But, with YSQL we see BEGIN transactions [Screen Shot 2022-02-18 at 5.50.26 AM] [Screen Shot 2022-02-18 at 5.50.17 AM] Why yugaware metrics does not show “local read” vs “remote read” metrics for YSQL? Does YSQL query plan …

So, any guess, How much time does it take for these tickets to get resolved? @sham_yuga This ticket is on our roadmap and will be taken up soon since we’ve seen increased interest for this feature in recent times. After that it may take around a few weeks to get it released.

[image] sham_yuga: Does YSQL query plan not include finding the shard owner? before executing the query… It does not. [image] sham_yuga: Why yugaware metrics does not show “local read” vs “remote read” metrics for YSQL? Because it’s still not possible to target the correct shard in YS…

@dorian_yugabyte Ok. Using YCQL, the query plan for INSERT would consist of: Finding shard owner, Execute query on shard owner, Find the replication node for that shard, Execute the query on replication node, Respond to client How does YSQL query plan work?

@sham_yuga The difference between YCQL and YSQL is where the process that you described previously actually happens currently. In YCQL, the driver has first hand information on shard locations / leaders via the system.partitions table. In YSQL, the driver has no special knowledge of this informat…

@Alan_Caldera For your point: “In YCQL, the driver has first hand information on shard locations / leaders via the system.partitions table.” I think this token aware feature from gocql driver to remember shard locations, is yet to be supported. Below are the tickets: https://github.com/yugabyte/y…

[image] sham_yuga: So, any guess, How much time does it take for these tickets to get resolved? @sham_yuga I’ve asked the assigned dev to reply on this thread.

Why "local reads" & "local writes" metrics does not exist with YSQL?

General

dorian_yugabyte February 21, 2022, 1:20pm 6

@sham_yuga I’ve asked the assigned dev to reply on this thread.

Is token(partition) aware policy supported by gocql driver?

Topic		Replies	Views
How to verify, if database is Cassandra DB or Yugabyte DB? General	5	7602	February 19, 2022
Cassandra to YSQL General	7	14307	January 9, 2026
Does Yugabyte Separate Cassandara and PostreSQL implementations? General	1	5179	August 6, 2020
Ysql high latency General	5	5250	April 7, 2025
Querying proper instance(leader) based on parition key General	4	5091	June 11, 2025

Why "local reads" & "local writes" metrics does not exist with YSQL?

Related topics