Welcome to the new Gigaspaces XAP forum. To recover your account, please follow these instructions.

Count Objects per Space Instance (Partition)

Hello ,

Please help me with a query to count the objects of a specific type that are stored in space (per partition). I have a space which has 4 partitions (2 working instances and 2 for backups) and various objects stored in these partitions.

I am using the XAP web interface and I want to see how many objects of a specific type are stored per partition. e.q

p1 : obj1, obj2 , obj3

p2: obj1, obj2

I want to see p1 => 3 , p2 => 2

So something like

select count(objID) from <ObjectType> group by <PartitionId>

Thanks, Alex

asked 2018-05-22 03:34:47 -0600

alextz
1 ●1 ●1

edit retag flag offensive close merge delete

add a comment

1 Answer

Sort by » oldest newest most voted

Hi,

In the web-ui click on the Spaces tab. Then click on -> in the right and we will see all partitions as rows. Choose one of the partition and run the query:
select count(*) from p1 where rowNum<5000

Run the same query when having one row (all partitions together) results the total count.

Thanks,

Yuval

answered 2018-05-23 04:14:30 -0600

Yuval
598 ●1 ●3

edit flag offensive delete link

add a comment

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Question Tools

1 follower

Stats

Asked: 2018-05-22 03:34:47 -0600

Seen: 102 times

Last updated: May 23 '18

Count Objects per Space Instance (Partition) edit

1 Answer