mongodb索引大小查看

2023-07-31 13:21 abce 阅读(138) 评论(0) 编辑收藏举报

查看数据库中索引总大小

> db.stats()
{
        "db" : "abce",
        "collections" : 258,
        "views" : 0,
        "objects" : 3869336,
        "avgObjSize" : 23033.87034752216,
        "dataSize" : 89125783755,
        "storageSize" : 49488015360,
        "indexes" : 489,
        "indexSize" : 132325376,
        "totalSize" : 49620340736,
        "scaleFactor" : 1,
        "fsUsedSize" : 113261400064,
        "fsTotalSize" : 214643507200,
        "ok" : 1,
        "$clusterTime" : {
                "clusterTime" : Timestamp(1690778757, 1),
                "signature" : {
                        "hash" : BinData(0,"ncIYGefuLs7KvMS1Acb99Ya3qF0="),
                        "keyId" : NumberLong("7232354472649818114")
                }
        },
        "operationTime" : Timestamp(1690778757, 1)
}

查看单个集合的索引大小：

1	`> db.getCollection("集合名").totalIndexSize();`

查看每个集合的索引大小：

> db.getCollectionNames().map(name => ({totalIndexSize: db.getCollection(name).stats().totalIndexSize, name: name})).sort((a, b) => a.totalIndexSize - b.totalIndexSize).forEach(printjson)
{ "totalIndexSize" : 8192, "name" : "asset_day.v1" }
{ "totalIndexSize" : 8192, "name" : "asset_day.v1.__in__" }
{ "totalIndexSize" : 8192, "name" : "p_day.v1" }
{ "totalIndexSize" : 8192, "name" : "p_day.v1.__in__" }
{ "totalIndexSize" : 8192, "name" : "swap_asset_day.v1" }
...
{ "totalIndexSize" : 786432, "name" : "index.com_daily" }
{ "totalIndexSize" : 794624, "name" : "style_tvalue.v1" }
{ "totalIndexSize" : 1634304, "name" : "ret_day.v1" }
{ "totalIndexSize" : 1740800, "name" : "nav_day.v1" }
{ "totalIndexSize" : 2670592, "name" : "lag_ret" }
{ "totalIndexSize" : 17883136, "name" : "pos" }
{ "totalIndexSize" : 17956864, "name" : "ret" }
{ "totalIndexSize" : 17956864, "name" : "pre_wt" }
{ "totalIndexSize" : 18001920, "name" : "otr" }
{ "totalIndexSize" : 18055168, "name" : "ostatus" }
{ "totalIndexSize" : 18120704, "name" : "owt" }
>

查看指定集合中索引的详细信息

> db.<集合名>.stats().indexSizes
{
        "_id_" : 230862848,
        "groupId_1_userId_1" : 49971200,
        "createTime_1" : 180301824,
        "orderId_1" : 278528,
        "userId_1" : 50155520
}