How to find or count all pages in AEM project?

We may find all the AEM pages using the SQL query. Run the below SQL query to get the count and list of all the cq:Page from your project.

SELECT * FROM [cq:Page] AS page WHERE ISDESCENDANTNODE(page ,"/content/project")

Below is the screenshot of the result and query execution steps. You may replace the path with your own project path e.g. /content/project 

Count of pages in AEM project