Hello Jack, The logs you are seeing are for queries taking longer than 50ms. We've increased this from 50ms to 2s for Postgres version 9.2 because of the useful pg_stat_statements view, a far better way to track slow or problematic queries than tailing logs or searching through logs.
If you migrate to a Postgres 9.2 database, it should definitely help with log volume. -Harold On Thu, May 16, 2013 at 11:25 PM, Jack Royal-Gordon <[email protected]>wrote: > I'm using LogEntries to store my sys logs, but I'm apparently generating a > very large log volume (~87GB/~270M events per day). My app has relatively > few users (100) who use it very lightly (16,665 HTTP Requests per day). > The main cause seems to be that my inserts can be very large (including > web pages that I have scraped), and when they are logged it includes the > entire contents of the web page (over 1000 lines per insert, 25,000 inserts > into the web page table per day). I have asked Heroku about any of the > following: > > 1) Shorten the logging entry from Postgres inserts to truncate the field > listings > 2) Disable the logging of long-running Heroku commands > > The response I got is that none of these is possible, and yet LogEntries > Support tells me that they had another user in the past who was able to get > Heroku to stop logging from their Postgres database. > > Does anyone know how to accomplish one of these tweaks? > > -- > -- > You received this message because you are subscribed to the Google > Groups "Heroku" group. > > To unsubscribe from this group, send email to > [email protected] > For more options, visit this group at > http://groups.google.com/group/heroku?hl=en_US?hl=en > > --- > You received this message because you are subscribed to the Google Groups > "Heroku Community" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- -- You received this message because you are subscribed to the Google Groups "Heroku" group. To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/heroku?hl=en_US?hl=en --- You received this message because you are subscribed to the Google Groups "Heroku Community" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
