Ask three systems how many pages a site has and get three answers. The analytics platform says 40,000, the crawler says 12,000, the CMS says 900. All three are counting different things.
Parameters explain most of the gap
Analytics counts every distinct URL that received a visit, including every tracking parameter combination. Strip the query strings, deduplicate, and the number collapses toward something recognisable.
The reconciliation is the finding
If 900 CMS pages generate 40,000 tracked URLs, that is a measurement problem worth fixing in the analytics configuration, and possibly an indexing problem worth fixing on the site.
Before you strip, check what you lose
Paginated URLs and genuine search or filter pages sometimes deserve to be counted separately. Look at the most common parameters first and decide which define content, then strip only the rest.
Try it: Strip Query Strings from URLs on SeoWolf's Notepad.