RE: Slow Running Queries in Azure PostgreSQL

2022-02-25 Thread Kumar, Mukesh
...@postgresql.org Subject: Re: Slow Running Queries in Azure PostgreSQL On Tue, Feb 22, 2022 at 02:11:58PM +, Kumar, Mukesh wrote: > -> Hash Join (cost=6484.69..43117.63 rows=1 width=198) (actual > time=155.508..820.705 rows=52841 loops=1)" >Hash Cond: (((lms_doc_property_right

Re: Slow Running Queries in Azure PostgreSQL

2022-02-22 Thread Justin Pryzby
On Tue, Feb 22, 2022 at 02:11:58PM +, Kumar, Mukesh wrote: > -> Hash Join (cost=6484.69..43117.63 rows=1 width=198) (actual > time=155.508..820.705 rows=52841 loops=1)" >Hash Cond: (((lms_doc_property_rights_assoc.doc_sid_c)::text = > (lms_doc_propright_status_assoc.doc_sid_c)::te