SLOW QUERY errors

Plex Media Server
,
34

After discussing this topic with some team members, I want to share some observations/suggestions.

  1. Please have debugging enabled
  2. The SLOW QUERY message may not be an indication to an issue
  • The time is recorded in ms, so 240.000000ms is still rather quick
  • If the time is greater 5s or 5000.000000ms, that would be significate and warrant investigation. This is an example not a threshold.
  1. Attempt to Optimize your DB and Clean Bundles
  2. Check your Plex Media Scanner Matcher.log and Plex Media Scanner Analysis.log for possible bad files, locked DB messages or other errors.
  3. It maybe worth mentioning your Settings > Library and Settings > Scheduled Tasks settings that pertain to scanning

I’m also curious if anyone is running any 3rd party apps or scripts that touch Plex that maybe invoking scans or metadata updates.

1 Like