How to get table/column statistics

[Jian Chen <ch...@gmail.com>]

Hi Igniters,

I am trying to get table statistics for a Ignite table, find the document
in
https://ignite.apache.org/docs/latest/monitoring-metrics/system-views#statistics_local_data

My question is: Is there any way to get the table/column complete
statistics rather than the local data on one node?

Thanks!
Yours sincerely

Stephen

Re: How to get table/column statistics

[Jian Chen <ch...@gmail.com>]

Thank you Alex,

But I just try on my local, see the sys.STATISTICS_GLOBAL_DATA table empty
while sys.STATISTICS_LOCAL_DATA contains the actual statistics, is it as
expected?

Yours Sincerely
Stephen

Jian Chen <ch...@gmail.com> 于2023年3月3日周五 16:56写道：

> wow that’s cool
>
> Alex Plehanov <pl...@gmail.com>于2023年3月3日 周五下午4:55写道：
>
>> Jian Chen,
>>
>> There is such a view as STATISTICS_GLOBAL_DATA, but looks like it isn't
>> documented.
>>
>> пт, 3 мар. 2023 г. в 11:13, Jian Chen <ch...@gmail.com>:
>>
>> > Hi Igniters,
>> >
>> > I am trying to get table statistics for a Ignite table, find the
>> document
>> > in
>> >
>> >
>> https://ignite.apache.org/docs/latest/monitoring-metrics/system-views#statistics_local_data
>> >
>> > My question is: Is there any way to get the table/column complete
>> > statistics rather than the local data on one node?
>> >
>> > Thanks!
>> > Yours sincerely
>> >
>> > Stephen
>> >
>>
>

Re: How to get table/column statistics

[Jian Chen <ch...@gmail.com>]

wow that’s cool

Alex Plehanov <pl...@gmail.com>于2023年3月3日 周五下午4:55写道：

> Jian Chen,
>
> There is such a view as STATISTICS_GLOBAL_DATA, but looks like it isn't
> documented.
>
> пт, 3 мар. 2023 г. в 11:13, Jian Chen <ch...@gmail.com>:
>
> > Hi Igniters,
> >
> > I am trying to get table statistics for a Ignite table, find the document
> > in
> >
> >
> https://ignite.apache.org/docs/latest/monitoring-metrics/system-views#statistics_local_data
> >
> > My question is: Is there any way to get the table/column complete
> > statistics rather than the local data on one node?
> >
> > Thanks!
> > Yours sincerely
> >
> > Stephen
> >
>

Re: How to get table/column statistics

[Alex Plehanov <pl...@gmail.com>]

Jian Chen,

There is such a view as STATISTICS_GLOBAL_DATA, but looks like it isn't
documented.

пт, 3 мар. 2023 г. в 11:13, Jian Chen <ch...@gmail.com>:

> Hi Igniters,
>
> I am trying to get table statistics for a Ignite table, find the document
> in
>
> https://ignite.apache.org/docs/latest/monitoring-metrics/system-views#statistics_local_data
>
> My question is: Is there any way to get the table/column complete
> statistics rather than the local data on one node?
>
> Thanks!
> Yours sincerely
>
> Stephen
>