Page Comparison

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

...

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

Navigate to Confluence's Cog wheel > General configuration

...

> Administration > Macro Usage:
Image Modified

...

Image Added

You can see all the macro usage information like the number of pages (link redirecting respective pages) that are using the app in the Macro Usage section as shown:
Image Modified

Usage information using SQL using SQL queries:

Connect to the Database Confluence 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"%');

...

If the query returns any records, it indicates that the Cache the Cache for Confluence app is being used. The above query gives the a result as shownsimilar to:
Image RemovedImage Added