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%	7.1%	28.9%	0.09	1
Server 2 - Hot Secondary (Falkenstein, DE) 91.99.189.202	ONLINE	0.0%	13.7%	5.6%	0.09	1
Server 3 - Warm Secondary (Helsinki, FI) 135.181.203.67	ONLINE	0.0%	35.6%	11.0%	0.19	1
Server 4 - Archive (Helsinki, FI) 46.62.223.214	ONLINE	0.0%	25.7%	8.9%	0.04	1
Server 5 - Arbiter (Ashburn, US) 178.156.199.143	ONLINE	1.0%	17.8%	20.1%	0.0	1

Replica Set Instances

Instance	Server	Status	State	Repl Lag	Connections	Uptime (hours)	Memory (MB)
Primary (Nuremberg)	Server 1 - Primary (Nuremberg, DE)	Online	PRIMARY	-	75	2.0h	3176 MB
Hot Secondary (Falkenstein)	Server 2 - Hot Secondary (Falkenstein, DE)	Online	SECONDARY	0s	51	2.0h	3621 MB
Warm Secondary (Helsinki)	Server 3 - Warm Secondary (Helsinki, FI)	Online	SECONDARY	0s	51	2.0h	10444 MB
Archive (Helsinki)	Server 4 - Archive (Helsinki, FI)	Online	SECONDARY	0s	52	2.0h	3607 MB
Arbiter (US)	Server 5 - Arbiter (Ashburn, US)	Online	ARBITER	N/A	0	2.0h	0 MB

Storage & Performance Metrics

💾 Storage

Data Size 8.67 GB

Index Size 1530 MB

Compression Snappy

🔄 WiredTiger Cache

Used / Total 2.8 / 30.2 GB

Utilization 9.3%

⚙️ System

Disk Usage 28.9%

Load Average 0.1

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
Clients	`systemID, _id`	207x	406.5 ms	515 ms	-	17418015	db.Clients.createIndex({"systemID": 1, "_id": 1})
Orders	`systemID, totalMargin`	51x	2230.0 ms	3517 ms	-	5800281	db.Orders.createIndex({"systemID": 1, "totalMargin": 1})
Orders	`systemID, totalQuantity`	49x	2095.2 ms	3539 ms	-	5030634	db.Orders.createIndex({"systemID": 1, "totalQuantity": 1})
Orders	`systemID, type, count`	29x	2128.9 ms	17814 ms	-	1790373	db.Orders.createIndex({"systemID": 1, "type": 1, "count": 1})
Orders	`inventory.shippingList.id, systemID`	8x	9189.4 ms	15655 ms	-	588120	db.Orders.createIndex({"inventory.shippingList.id": 1, "systemID": 1})
Orders	`systemID, shipping.company, company, total`	24x	937.6 ms	1514 ms	-	540072	db.Orders.createIndex({"systemID": 1, "shipping.company": 1, "company": 1, "total": 1})
Orders	`systemID, count`	19x	1450.7 ms	1533 ms	-	523716	db.Orders.createIndex({"systemID": 1, "count": 1})
Orders	`systemID, type, inventoryStatus.delivery, dates.shippedDate`	21x	476.9 ms	500 ms	-	210294	db.Orders.createIndex({"systemID": 1, "type": 1, "inventoryStatus.delivery": 1, "dates.shippedDate": 1})
Stock	`systemID, isBundle, _id`	29x	158.1 ms	1299 ms	-	132936	db.Stock.createIndex({"systemID": 1, "isBundle": 1, "_id": 1})
Orders	`systemID, type, inventoryStatus.delivery, dates.shippedDate, _id`	14x	493.0 ms	565 ms	-	96628	db.Orders.createIndex({"systemID": 1, "type": 1, "inventoryStatus.delivery": 1, "dates.shippedDate": 1, "_id": 1})
Orders	`systemID, type, inventoryStatus.sales, count`	36x	69.3 ms	104 ms	-	89856	db.Orders.createIndex({"systemID": 1, "type": 1, "inventoryStatus.sales": 1, "count": 1})
Orders	`systemID, type, _id`	9x	923.9 ms	1875 ms	-	74835	db.Orders.createIndex({"systemID": 1, "type": 1, "_id": 1})
Clients	`name, systemID, createdAt`	11x	606.4 ms	2555 ms	-	73370	db.Clients.createIndex({"name": 1, "systemID": 1, "createdAt": 1})
Clients	`name, systemID`	13x	392.2 ms	2598 ms	-	66287	db.Clients.createIndex({"name": 1, "systemID": 1})
Orders	`systemID, salesDetails.tags, createdAt`	2x	14963.5 ms	15143 ms	-	59854	db.Orders.createIndex({"systemID": 1, "salesDetails.tags": 1, "createdAt": 1})