How to find the count of relationships by relatinship type in Neo4J database

Question

I want to check how many relationship types are in the database. Also, how many relationships by each type are there in the database?

Answer 1

You can try the following Cypher query to get the number of relationships by relationship type.

MATCH ()-[r]-() 

RETURN TYPE(r) AS relationshipType, COUNT(r) AS relationshipCount;

Comments

The above Cypher will return 2x count for each relationship type because of the bi-directional match. To get unique counts, you need to use "MATCH ()-[r]->()".

Also, you can use the apoc.meta.status() procedure to get the unique count of each relationship type. Here is an example:

CALL apoc.meta.stats() YIELD relTypesCount
RETURN relTypesCount