Enable logging in the Matomo (Piwik) UI: by default, Matomo logs messages in the UI (using notification boxes). If you want additional logging details, or if you want to enable logging to a file you can edit your config.ini.php and set the following options:

You may also enable SQL logging & profiling to see the list of SQL queries executed by Matomo (Piwik) on any given page or widget. First, enable logging on screen (see point above). Then, edit your config.ini.php and add the following:

[Debug]
enable_sql_profiler = 1

Matomo (Piwik) will then output all SQL queries, group them by unique query, and show the total time spent as well as average time spent on each query.

Thanks for contacting us! We will get in touch with you shortly.

Feedback on this page

Name (required)

Email (required)

Your feedback (required)

Your information will be used only to improve our pages and to answer you. Your data will be processed by us, our hosting provider, and our support ticket provider. For more information have a look at our privacy policy.

Become a partner

Privacy

Sign up for our newsletter

We are constantly adding new features and content to the leading All-In-One Analytics Platform that gives you control over your data. If you want to stay up to date with everything that is happening, feel free to subscribe below. You can unsubscribe at any time from it. The newsletter service uses MadMimi. Learn more about it within our privacy Policy page.