Hi Thushara, Just to double-check: Is your database indexed correctly? Have you tried plugging in something like lol_dba gem to spot missing indexes?
Sent from my iPhone > On Feb 25, 2020, at 10:21 PM, Thushara Wijeratna <thu...@gmail.com> wrote: > > > Hi All, > > I have a Rails app (rails version 5.2.4.1 / ruby 2.6.3) that makes queries to > a postgres database using ActiveRecord. > I want to reduce query latency. > > I'm using NewRelic to understand what the slow queries are, and I see pretty > much each one of them is spending time inside the `mon_synchronize` method in > monitor.rb > https://github.com/ruby/ruby/blob/12c7321d758c736d42dbbd36c74628f7a243851e/lib/monitor.rb#L230 > > I'm attaching a few screenshots from NewRelic. > > My question is - what is the reason ActiveRecord is taking this lock? Is > there anything I can do to get a better response from the queries. > > The database itself is pretty small - thousands of records. > > thanks, > thushara > > > -- > You received this message because you are subscribed to the Google Groups > "Ruby on Rails: Core" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to rubyonrails-core+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/rubyonrails-core/b5e55010-a295-4d3d-8402-0582a5f5b6f3%40googlegroups.com. > <Screen Shot 2020-02-25 at 9.42.14 AM.png> > <Screen Shot 2020-02-25 at 9.43.14 AM.png> > <Screen Shot 2020-02-25 at 9.46.06 AM.png> -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Core" group. To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-core+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-core/D86FF58A-0793-4A68-93C5-DDEA4317F165%40josh.mn.