Guido Neitzer wrote:
Hi.

Is there a way to set up logging in a way that I can see queries which trigger seq scans? Or to log queries "taking longer than xx ms"?

The second is straightforward. See the "log_min_duration_statement" setting in the "logging" section of the manuals.

--
  Richard Huxton
  Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to