sizingpipelines.py

pipeline = [
    {
        '$match': {
            'collections': {
                '$exists': 1
            }
        }
    }, {
        '$group': {
            '_id': '$sourcefile', 
            'data_size_without_compression_GB': {
                '$sum': {
                    '$divide': [
                        '$dataSize', 1073741824
                    ]
                }
            }, 
            'index_size_GB': {
                '$sum': {
                    '$divide': [
                        '$indexSize', 1073741824
                    ]
                }
            }, 
            'index_size_GB': {
                '$sum': {
                    '$divide': [
                        '$indexSize', 1073741824
                    ]
                }
            }, 
            'storage_size_compressed_GB': {
                '$sum': {
                    '$divide': [
                        '$storageSize', 1073741824
                    ]
                }
            },
            'total_objects': {
                '$sum': '$objects'
            }, 
            'total_objects_in_Millions': {
                '$sum': {
                    '$divide': [
                        '$objects', 1000000
                    ]
                }
            }, 
            'total_indices': {
                '$sum': '$indexes'
            }, 
            'total_collections': {
                '$sum': '$collections'
            }, 
            'databases': {
                '$push': {
                    'database': '$db',
                    'collections': '$collections', 
                    'numIndices': '$indexes'                    
                }
            }
        }
    }
]


status_pipeline = [{
    "$project": {
    "network_Out_GB":{
        '$divide': [
            "$network.bytesOut",
            1073741824
        ]
    },
        "network_In_GB":{
        '$divide': [
            "$network.bytesIn",
            1073741824
        ]
    },
    "uptime_Days":{
        "$divide": [
        "$uptime", 86400
        ]
    },
        "uptime_Years":{
        "$divide": [
        "$uptime", 31536000
        ]
    },
    "query_stats_In_Millions": {
        "inserts" : {
        "$divide":["$opcounters.insert",1000000]
        },
        "query" : {
        "$divide":["$opcounters.query",1000000]
        },
        "getmore" : {
        "$divide":["$opcounters.getmore",1000000]
        },
        "command" : {
        "$divide":["$opcounters.command",1000000]
        },
        "delete" : {
        "$divide":["$opcounters.delete",1000000]
        }
    },
    "query_stats_raw": {
        "inserts" : "$opcounters.insert",
        "query" : "$opcounters.query",
        "getmore" : "$opcounters.getmore",
        "command" : "$opcounters.command",
        "delete" : "$opcounters.delete",
    },
    "replicationStats":"$replicationStats"
}}]