How to get the usage information of Cache for Confluence app

This article explains how to get a list of Confluence pages in the respective spaces where the Cache for Confluence app is used.

Instructions

Usage information from the Macro Usage option in the Confluence Administration section:

1. Navigate to Confluence's General configuration from the cogwheel:
   
2. Navigate to Macro Usage from Administration on the left side panel:
   
3. In the Macro Usage section, you can see all the macro usage information like the number of pages (link redirecting respective pages) that are using the app:
   

Usage information using SQL queries:

Connect to the Database and run the following database query:

Select CONTENT.Title, CONTENT.SpaceID from CONTENT, BODYCONTENT 
WHERE PREVVER IS NULL AND (CONTENT.CONTENTTYPE = 'PAGE' OR CONTENT.CONTENTTYPE = 'BLOGPOST')
 AND CONTENT.CONTENTID = BODYCONTENT.CONTENTID
 AND (BODYCONTENT.BODY like '%<ac:structured-macro ac:name="cache"%');

Sample Results:

If the query returns any records, it indicates that the Cache for Confluence app is being used. The above query gives the result as shown: