Beginner LevelMongoDB & Mongoose
How do dbStats and collStats track database storage and index memory size?
❓ Interview Prompt: Explain database diagnostic commands (db.stats(), db.collection.stats()), monitoring document counts, dataSize, storageSize, and indexSize.
Monitoring database storage and index footprints relies on diagnostic stat commands:
•
'db.stats()': Reports total uncompressed 'dataSize', allocated filesystem 'storageSize', and total 'indexSize' for the active database.
•
'db.collection.stats()': Reports document count, average document size, and memory usage per index.
Code Implementation Example
typescript
import mongoose from 'mongoose';
async function checkCollectionStats() {
const db = mongoose.connection.db;
const stats = await db!.command({ collStats: 'orders' });
console.log('Total Documents:', stats.count);
console.log('Storage Size (MB):', (stats.storageSize / 1024 / 1024).toFixed(2));
console.log('Total Index Size (MB):', (stats.totalIndexSize / 1024 / 1024).toFixed(2));
}💡Checking collection storage and index memory footprints using collStats.
🎯 Interview Key Takeaway
Monitor index memory usage with collStats to ensure active index working sets fit entirely inside available system RAM.
#collStats#dbStats#Monitoring#Indexes#Beginner
Back to all MongoDB & Mongoose Questions→