Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
From: Oskar Kjellin <oskar.kjellin@gmail.com>
Content-Type: multipart/alternative;
	boundary=Apple-Mail-A894A8C2-2E3C-4D70-B624-A026CCCD223E
Content-Transfer-Encoding: 7bit
Mime-Version: 1.0 (1.0)
Date: Mon, 13 Mar 2017 19:40:16 +0100
Subject: Re: How to obtain partition size
Message-Id: <B53A87DB-B7C3-4825-A884-EE03096A0D0A@gmail.com>
References: <CAM737NJc=dO1n3wBSJRDOecTWNxWrdPtqcmn4sOxe2EzCVwghg@mail.gmail.com>
In-Reply-To: <CAM737NJc=dO1n3wBSJRDOecTWNxWrdPtqcmn4sOxe2EzCVwghg@mail.gmail.com>
To: user@cassandra.apache.org
archived-at: Mon, 13 Mar 2017 18:40:24 -0000


--Apple-Mail-A894A8C2-2E3C-4D70-B624-A026CCCD223E
Content-Type: text/plain;
	charset=us-ascii
Content-Transfer-Encoding: quoted-printable

How about this tool?

https://github.com/instaclustr/cassandra-sstable-tools

> On 13 Mar 2017, at 17:56, Artur R <artur@gpnxgroup.com> wrote:
>=20
> Hello!
>=20
> I can't find where C* stores information about partitions size (if stores i=
t at all).
> So, the questions;
>=20
>  1. How to obtain the size (in rows or in bytes - doesn't matter) of some p=
articular partition?
> I know that there is system.size_estimates table with mean_partition_size,=
 but it's only mean size among all partitions.
>=20
>  2. How to obtain the size of entire table?
> Again, does "mean_partition_size * partitions_count" (fields from system.s=
ize_estimates table) =3D=3D real size of the table?
>=20
>  3. Is it possible to obtain size of rows by some clustering key within so=
me partition?
>=20
>=20
> Maybe one can obtain these information using Java driver or from C* system=
 tables?
>=20
>=20
>=20

--Apple-Mail-A894A8C2-2E3C-4D70-B624-A026CCCD223E
Content-Type: text/html;
	charset=utf-8
Content-Transfer-Encoding: quoted-printable

<html><head><meta http-equiv=3D"content-type" content=3D"text/html; charset=3D=
utf-8"></head><body dir=3D"auto"><div>How about this tool?</div><div id=3D"A=
ppleMailSignature"><br><a href=3D"https://github.com/instaclustr/cassandra-s=
stable-tools">https://github.com/instaclustr/cassandra-sstable-tools</a><br>=
</div><div><br>On 13 Mar 2017, at 17:56, Artur R &lt;<a href=3D"mailto:artur=
@gpnxgroup.com">artur@gpnxgroup.com</a>&gt; wrote:<br><br></div><blockquote t=
ype=3D"cite"><div><div dir=3D"ltr">Hello!<br><br>I can't find where C* store=
s information about partitions size (if stores it at all).<br>So, the questi=
ons;<br><br>&nbsp;1. How to obtain the size (in rows or in bytes - doesn't m=
atter) of some particular partition?<br>I know that there is&nbsp;<i>system.=
size_estimates</i> table&nbsp;with&nbsp;<i>mean_partition_size</i>, but it's=
 only mean size among all&nbsp;partitions.<br><br><div>&nbsp;2. How to obtai=
n the size of entire table?<br>Again, does "mean_partition_size * partitions=
_count" (fields from <i>system.size_estimates</i> table) =3D=3D real size of=
 the table?</div><div><br></div><div>&nbsp;3. Is it possible to obtain size o=
f rows by some clustering key within some partition?</div><div><br></div><di=
v><br></div><div>Maybe one can obtain these information using Java driver or=
 from C* system tables?</div><div><br></div><div><br></div><div><br></div></=
div>
</div></blockquote></body></html>=

--Apple-Mail-A894A8C2-2E3C-4D70-B624-A026CCCD223E--