Neo4j查找数据库的最大字节大小

Question

我找到了关于如何计算neo4j数据库大小的以下信息:https://neo4j.com/developer/guide-sizing-and-hardware-calculator/#_disk_storage

match (n) return count(n);

match (n)-[r]-() return count(r);

Answer 1

回答您的主要问题，使用keys函数获取属性名称列表并汇总它们的长度：

MATCH (n)
WITH SUM(SIZE(KEYS(n))) AS countOfNodeProps, 
     COUNT(n) AS countOfNodes
MATCH ()-[r]->()
WITH countOfNodeProps,
     countOfNodes,
     SUM(SIZE(KEYS(r))) AS countOfRelProps,
     COUNT(r) AS countOfRels
RETURN countOfNodeProps,
       countOfRelProps,
       (countOfNodeProps + countOfRelProps) as countOfProps,
       countOfNodes,
       countOfRels

但是使用apoc.monitor.store函数更容易获得关于存储的确切信息：

CALL apoc.monitor.store() YIELD 
    logSize, 
    stringStoreSize, 
    arrayStoreSize, 
    relStoreSize, 
    propStoreSize, 
    totalStoreSize, 
    nodeStoreSize
RETURN *