MongoDB Production Dashboard

Server System Metrics

Server	Status	CPU Usage	RAM Usage	Disk Usage	Load Average	MongoDB Processes
Server 1 - Primary (Nuremberg, DE) 91.98.162.254	ONLINE	0.1%	13.7%	27.9%	0.12	1
Server 2 - Hot Secondary (Falkenstein, DE) 91.99.189.202	ONLINE	0.3%	9.2%	5.1%	0.01	1
Server 3 - Warm Secondary (Helsinki, FI) 135.181.203.67	ONLINE	0.0%	35.2%	34.6%	0.07	1
Server 4 - Archive (Helsinki, FI) 46.62.223.214	ONLINE	0.5%	9.3%	8.3%	0.06	1
Server 5 - Arbiter (Ashburn, US) 178.156.199.143	ONLINE	0.0%	17.0%	19.8%	0.04	1

Replica Set Instances

Instance	Server	Status	State	Repl Lag	Connections	Uptime (hours)	Memory (MB)
Primary (Nuremberg)	Server 1 - Primary (Nuremberg, DE)	Online	PRIMARY	-	43	80.7h	7311 MB
Hot Secondary (Falkenstein)	Server 2 - Hot Secondary (Falkenstein, DE)	Online	SECONDARY	0s	27	80.7h	2226 MB
Warm Secondary (Helsinki)	Server 3 - Warm Secondary (Helsinki, FI)	Online	SECONDARY	0s	27	80.7h	10328 MB
Archive (Helsinki)	Server 4 - Archive (Helsinki, FI)	Online	SECONDARY	0s	24	80.7h	979 MB
Arbiter (US)	Server 5 - Arbiter (Ashburn, US)	Online	ARBITER	N/A	0	80.6h	0 MB

Storage & Performance Metrics

💾 Storage

Data Size 8.41 GB

Index Size 780 MB

Compression Snappy

🔄 WiredTiger Cache

Used / Total 6.3 / 30.2 GB

Utilization 20.9%

⚙️ System

Disk Usage 27.9%

Load Average 0.12

Processes 1

Security & Backup Status

🔒 Security

TLS Encryption ✅ Enabled

CN=*.database.babrizq.co

Authentication ✅ SCRAM-SHA-256

💾 Backup Status

Last Backup N/A

No backups found

Location

                                    /tmp/mongodb-backups (empty)
                                

🎯 Missing Indexes - Recommendations (Last 7 Days)

Collection	Fields to Index	Hit Count	Avg Time	Max Time	COLLSCAN	Impact Score	Create Command
Orders	`systemID, totalQuantity`	156x	566.4 ms	992 ms	-	13782912	db.Orders.createIndex({"systemID": 1, "totalQuantity": 1})
Orders	`systemID, totalMargin`	153x	567.0 ms	981 ms	-	13272750	db.Orders.createIndex({"systemID": 1, "totalMargin": 1})
OrderReasons	`systemID, stage, notes, total`	121x	104.3 ms	210 ms	-	1527262	db.OrderReasons.createIndex({"systemID": 1, "stage": 1, "notes": 1, "total": 1})
Orders	`systemID, shipping.company, company, total`	34x	360.6 ms	481 ms	-	416908	db.Orders.createIndex({"systemID": 1, "shipping.company": 1, "company": 1, "total": 1})
Orders	`systemID, inventoryStatus.warehouse, inventoryStatus.delivery, type, createdAt`	65x	78.1 ms	90 ms	-	330135	db.Orders.createIndex({"systemID": 1, "inventoryStatus.warehouse": 1, "inventoryStatus.delivery": 1, "type": 1, "createdAt": 1})
Orders	`systemID, inventoryStatus.warehouse, stockDetails, totalQuantity`	27x	73.4 ms	103 ms	-	53541	db.Orders.createIndex({"systemID": 1, "inventoryStatus.warehouse": 1, "stockDetails": 1, "totalQuantity": 1})
Orders	`systemID, createdAt, inventoryStatus.warehouse, stockDetails, totalQuantity`	29x	59.8 ms	82 ms	-	50286	db.Orders.createIndex({"systemID": 1, "createdAt": 1, "inventoryStatus.warehouse": 1, "stockDetails": 1, "totalQuantity": 1})
Movements	`systemID, purchase.purchaseUID`	4x	1090.5 ms	1244 ms	-	17448	db.Movements.createIndex({"systemID": 1, "purchase.purchaseUID": 1})
Picking	`systemID, _id`	6x	194.0 ms	284 ms	-	6984	db.Picking.createIndex({"systemID": 1, "_id": 1})
Purchases	`systemID, _id`	7x	133.9 ms	169 ms	-	6559	db.Purchases.createIndex({"systemID": 1, "_id": 1})
Orders	`systemID, salesDetails.assignee, type, salesDetails.lastUpdated, createdAt`	9x	63.8 ms	78 ms	-	5166	db.Orders.createIndex({"systemID": 1, "salesDetails.assignee": 1, "type": 1, "salesDetails.lastUpdated": 1, "createdAt": 1})
Orders	`systemID, salesDetails.assignee, type, createdAt`	4x	214.0 ms	224 ms	-	3424	db.Orders.createIndex({"systemID": 1, "salesDetails.assignee": 1, "type": 1, "createdAt": 1})
Orders	`systemID, createdAt, totalQuantity`	6x	82.7 ms	93 ms	-	2976	db.Orders.createIndex({"systemID": 1, "createdAt": 1, "totalQuantity": 1})
OrderReasons	`systemID, createdAt, stage, notes, total`	6x	60.8 ms	66 ms	-	2190	db.OrderReasons.createIndex({"systemID": 1, "createdAt": 1, "stage": 1, "notes": 1, "total": 1})
Orders	`systemID, createdAt, totalMargin`	5x	75.0 ms	87 ms	-	1875	db.Orders.createIndex({"systemID": 1, "createdAt": 1, "totalMargin": 1})