Re: Request to help on Query improvement suggestion.

2020-07-11 Thread Marlene Villanueva
On Sun, May 24, 2020, 11:48 PM Laurenz Albe wrote: > On Fri, 2020-05-22 at 16:15 +0530, devchef2020 d wrote: > > PostgreSQL : 9.5.15 > > > Created Indexes on column parental_path: > > = > > > > CREATE INDEX cable_pair_parental_path_idx > > ON SCHEMA.TABLE_NAME >

Re: Request to help on Query improvement suggestion.

2020-05-24 Thread Laurenz Albe
On Fri, 2020-05-22 at 16:15 +0530, devchef2020 d wrote: > PostgreSQL : 9.5.15 > Created Indexes on column parental_path: > = > > CREATE INDEX cable_pair_parental_path_idx > ON SCHEMA.TABLE_NAME > USING btree > (md5(parental_path) COLLATE pg_catalog."default")

Request to help on Query improvement suggestion.

2020-05-22 Thread devchef2020 d
Hi Team, Thanks for your support. Could someone please suggest on the below query. One of the query which was created on GIS data is taking a long time and even it is not taking the index as well. I have included all the required details for reference. Database Stack: === PostgreSQL