How to call db.Collection.stats() from Mongo java driver

Question

From Mongodb client, we can use db.Collection.stats() to get status of collections, such as:
+ Number of records (count)
+ Size on disk (storageSize)
+ Indexes (indexSizes)
+ Average object size (avgObjSize)

Now I want to monitor these data from web backend with Mongodb java driver, please let me know how to get them?

I've referred: http://mongodb.github.io/mongo-java-driver/3.0/driver-async/getting-started/quick-tour-admin/ but it's not enough information for me.

Thanks!

As of MongoDB Java driver version 3.0 and later (3.12+), use the database.runCommand() method to get the collection statistics document; see stackoverflow.com/questions/61052446/… — prasad_
– prasad_, Commented Apr 6, 2020 at 5:49

beluga · Accepted Answer · 2016-05-27 15:03:06Z

10

@Yoshiya (sorry, don't have enough rep for comment permission)

This works for me on 3.2 driver (kindly provided by Kay Kim from the Mongo folks)

MongoDatabase database = mongoClient.getDatabase("mydb");
Document stats = database.runCommand(new Document("collStats", "myCollection"));

answered May 27, 2016 at 15:03

beluga

3224 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Naman Over a year ago

is the Document, org.bson.Document? also could you link your answer or elaborate on what collStats, myCollection etc are

beluga Over a year ago

@nullpointer - Ok, I wanted to keep this as small and concise as possible and assumed people would just google the official doc for these questions, but sure... 1. Yes, it is org.bson.Document 2. For collStats please see: docs.mongodb.com/manual/reference/command/collStats 3. 'myCollection' refers to the name of the mongo collection you want to run 'collStats' (see above) on Basically this is just workable Java syntax for officially documented mongo commands. Hope that helps.

Neo-coder · Accepted Answer · 2015-06-25 07:51:13Z

4

Use CommandResult to finding collection stat in java check below code :

Mongo mongo = new Mongo("localhost", 27017);
DB db = mongo.getDB("data base name");
CommandResult resultSet = db.getCollection("collectionName").getStats();
System.out.println(resultSet);
System.out.println(resultSet.get("count"));
System.out.println(resultSet.get("avgObjSize"))

edited Jun 25, 2015 at 7:51

answered Jun 25, 2015 at 7:17

Neo-coder

7,8585 gold badges36 silver badges54 bronze badges

2 Comments

nhthai Over a year ago

That's great! Work for me. Please update variable cursorDoc to resultSet.

Yoshiya Over a year ago

Does anyone know how to do this with the MongoDB Java driver 3.2 without using these deprecated classes?

Aman · Accepted Answer · 2015-06-25 10:27:29Z

1

This will work:

CommandResult resultSet = db.getCollection("emp").getStats();
        System.out.println(resultSet);

you will get all the details of status.ouput:

{ "ns" : "test.emp" , "count" : 2 , "size" : 96 , "avgObjSize" : 48 , "numExtents" : 1 , "storageSize" : 8192 , "lastExtentSize" : 8192.0 , "paddingFactor" : 1.0 , "paddingFactorNote" : "paddingFactor is unused and unmaintained in 3.0. It remains hard coded to 1.0 for compatibility only." , "userFlags" : 1 , "capped" : false , "nindexes" : 1 , "indexDetails" : { } , "totalIndexSize" : 8176 , "indexSizes" : { "_id_" : 8176} , "ok" : 1.0}

answered Jun 25, 2015 at 10:27

Aman

3,2717 gold badges39 silver badges60 bronze badges

Collectives™ on Stack Overflow

How to call db.Collection.stats() from Mongo java driver

3 Answers 3

2 Comments

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related