Return count of relationships instead of all

Question

I wonder if anyone can advise how to adjust the following query so that it returns one relationship with a count of the number of actual relationships rather than every relationship? I have some nodes with many relationships and it's killing the graph's performance.

MATCH (p:Provider{countorig: "XXXX"})-[r:supplied]-(i:Importer)
RETURN p,  i limit 100

Many thanks

Answer 1

To return the relationship name along with a count, change your "return" statement, like this:

MATCH (p:Provider{countorig: "XXXX"})-[r:supplied]-(i:Importer)
RETURN type(r), count(r)

Using type(r) will return the type of the relationship, which looks to be "supplied" in your example. And then count(r) is just using the built-in function to count the number of occurrences of that relationship in the query.