Logical reads

Hi listers, Is there any sql query which we can use to find the logical reads performed by particular sql statement in postgres ?? Thanks, Goti -- Thanks, Goti

Re: How to find the final transformed query in postgresql

Thanks a lot Tom. Thanks, Goti On Mon, Apr 18, 2022 at 7:43 PM Tom Lane wrote: > Goti writes: > > I would like to know if postgres performs any transformations when it > does > > the parsing? > > This might be helpful reading: > > https://www.postgresql.

How to find the final transformed query in postgresql

? Thanks, Goti

SQL performance issue after migration from Oracle to Aurora postgres

postgres and trying to get some ideas around how better we can optimize. I have the plan details for the SQL as below. Can someone shed some light on possible ways that can make this query to meet its original execution time? https://explain.depesz.com/s/jlVc#html Thanks, Goti