Free clean up database module for PrestaShop to speed up your store

Over time, PrestaShop's statistics module silently fills your database with thousands of records tracking visitor connections, referral sources, and guest profiles. This module targets those three specific tables — ps_connection, ps_connections_source, and ps_guest — and clears them out to restore database performance and reduce page load times on both the front office and back office.

• Cleans the ps_connection table, which logs every new connection to the store when the Data Mining for Statistics module is active
• Cleans the ps_connections_source table, which records visitor referral paths and inter-page navigation data
• Cleans the ps_guest table, which stores per-visitor metadata such as browser type, screen resolution, operating system, and language
• Simple, focused scope — no configuration required beyond running the cleanup

This module is a practical first step for store owners who have the Data Mining for Statistics module installed and notice degraded performance on high-traffic stores. Because those three tables can reach tens of thousands of rows, clearing them can measurably reduce query times. It is intentionally basic and does not touch other database tables; store owners who need broader cleanup may want to evaluate the developer's paid advanced version.