[
https://issues.apache.org/jira/browse/CASSANDRA-20161?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17907623#comment-17907623
]
Chris Lohfink commented on CASSANDRA-20161:
-------------------------------------------
{{other than providing a size and number of sstables each key exists in its
much faster and cheaper than the distinct id query if ok with not worrying
about tombstones.}}
{{DISTINCT ID}}{code}
Writes Reads
Deletes Errors
Count Latency (p99) 1min (req/s) | Count Latency (p99) 1min (req/s) |
Count Latency (p99) 1min (req/s) | Count 1min (errors/s)
0 0 0 | 246 1641.35 0 |
0 0 0 | 0 0
0 0 0 | 795 3544.27 111.2 |
0 0 0 | 0 0
0 0 0 | 2050 4219.31 111.2 |
0 0 0 | 0 0
0 0 0 | 3600 4259.02 134.36 |
0 0 0 | 0 0
0 0 0 | 5165 4292.96 165.16 |
0 0 0 | 0 0
0 0 0 | 6737 5788.62 165.16 |
0 0 0 | 0 0
0 0 0 | 8203 7130.96 193.55 |
0 0 0 | 0 0
0 0 0 | 9822 8682.5 193.55 |
0 0 0 | 0 0
0 0 0 | 11428 10588.99 219.3 |
0 0 0 | 0 0
0 0 0 | 12626 12007.37 238.32 |
0 0 0 | 1340 21.43
Writes Reads
Deletes Errors
Count Latency (p99) 1min (req/s) | Count Latency (p99) 1min (req/s) |
Count Latency (p99) 1min (req/s) | Count 1min (errors/s)
0 0 0 | 13023 12014.16 238.32 |
0 0 0 | 5700 21.43
0 0 0 | 13212 12014.44 228.3 |
0 0 0 | 11734 154.3
0 0 0 | 13639 12023.06 228.3 |
0 0 0 | 18315 154.3
0 0 0 | 13975 12047.96 218.97 |
0 0 0 | 25496 316.69
0 0 0 | 14032 12047.96 206.03 |
0 0 0 | 34401 510.59{code}
{{PrinaryId}}
{code}
Writes Reads
Deletes Errors
Count Latency (p99) 1min (req/s) | Count Latency (p99) 1min (req/s) |
Count Latency (p99) 1min (req/s) | Count 1min (errors/s)
0 0 0 | 1046 210.13 0 |
0 0 0 | 0 0
0 0 0 | 2547 201.5 407.6 |
0 0 0 | 0 0
0 0 0 | 4045 167.2 407.6 |
0 0 0 | 0 0
0 0 0 | 6542 112.58 414.99 |
0 0 0 | 0 0
0 0 0 | 9543 74.58 461.62 |
0 0 0 | 0 0
0 0 0 | 14046 32.86 461.62 |
0 0 0 | 0 0
0 0 0 | 19045 10.22 544.63 |
0 0 0 | 0 0
0 0 0 | 25049 8.48 544.63 |
0 0 0 | 0 0
0 0 0 | 32048 9.4 660.9 |
0 0 0 | 0 0
0 0 0 | 39551 9.09 807.85 |
0 0 0 | 0 0
Writes Reads
Deletes Errors
Count Latency (p99) 1min (req/s) | Count Latency (p99) 1min (req/s) |
Count Latency (p99) 1min (req/s) | Count 1min (errors/s)
0 0 0 | 48553 10 807.85 |
0 0 0 | 0 0
0 0 0 | 58055 11.57 983.17 |
0 0 0 | 0 0
0 0 0 | 68564 33.48 983.17 |
0 0 0 | 0 0
0 0 0 | 77128 646.1 1184.45 |
0 0 0 | 0 0
{code}
> Virtual table to query partition keys in a table
> ------------------------------------------------
>
> Key: CASSANDRA-20161
> URL: https://issues.apache.org/jira/browse/CASSANDRA-20161
> Project: Apache Cassandra
> Issue Type: New Feature
> Components: Feature/Virtual Tables
> Reporter: Chris Lohfink
> Assignee: Chris Lohfink
> Priority: Normal
>
> Introduce a new virtual table, {{{}PrimaryIdTable{}}}, to allow users to
> query partition keys and related metadata for a specific table within a
> keyspace. This feature provides insights into SSTable-level details, such as
> token values, size estimates, and SSTable counts, without requiring expensive
> disk-based operations.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
