如何在postgres查询中按正则表达式进行分组

I'm cleaning up someone else's restful application, and in doing so it appears that there are some routes that aren't being used. To begin troubleshooting, I created a table with a unique text column to store the route. I'm cleaning up someone else's restful applicat