Re: lwlock:LockManager wait_events

2025-02-08 Thread kyle Hailey
late to the game here but this might be of interest: https://ardentperf.com/2024/03/03/postgres-indexes-partitioning-and-lwlocklockmanager-scalability/ On Fri, Oct 25, 2024 at 5:10 AM SAMEER KUMAR wrote: > > > On Fri, 25 Oct 2024, 14:36 James Pang, wrote: > >> experts, >> we faced into

Re: How do Monitoring tools capture explain plan of a query

2023-04-22 Thread kyle Hailey
Datadog runs explain on a subset of queries , should be most of the top queries, and doesn't use auto_explain (though there is an request to use it if it is already set up) Kyle On Sat, Apr 22, 2023 at 8:29 AM kunwar singh wrote: > Postgres noob question. > > For example say datadog > https:

Re: Is there any tool which will help me run and explain analyze about 150 queries?

2023-04-08 Thread kyle Hailey
Just wrote up my experiences setting up auto_explain on Google Cloud SQL to get explain analyze: https://www.kylehailey.com/post/auto_explain-on-google-cloud-sql-gcp On Fri, Apr 7, 2023 at 9:40 PM Jerry Sievers wrote: > kunwar singh writes: > > > Hi Listers, > > Anyone here use such a tool

Re: Is there any tool which will help me run and explain analyze about 150 queries?

2023-04-07 Thread kyle Hailey
In my opinion, Datadog is the best Postgres monitor available, but it doesn't have a feature that has been discussed. However, you can use auto_explain to analyze long-running queries by setting a limit. I recently enabled it in GCP Cloud SQL, but I haven't seen any results in the logs yet. I need