On Feb 25, 2020, at 10:21 PM, Thushara Wijeratna <thu...@gmail.com> wrote:
--
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-co...@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>
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 iPhoneOn 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.rbI'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 rubyonra...@googlegroups.com.