Re: Suggestion to improve query performance for GIS query.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Dear team,

Kindly try to execute the vacuum analyzer on that particular table and refresh the session and execute the query.

VACUUM (VERBOSE, ANALYZE) tablename;

Regards,
Mohammed Afsar
Database engineer

On Fri, May 22, 2020, 12:30 PM postgann2020 s <postgann2020@xxxxxxxxx> wrote:
Hi Team,

Thanks for your support.

Could you please suggest on below query.

EnvironmentPostgreSQL: 9.5.15
Postgis: 2.2.7

The table contains GIS data which is fiber data(underground routes).

We are using the below query inside the proc which is taking a long time to complete.

*************************************************************

SELECT seq_no+1 INTO pair_seq_no FROM SCHEMA.TABLE WHERE (Column1 like '%,sheath--'||cable_seq_id ||',%' or Column1 like 'sheath--'||cable_seq_id ||',%' or Column1 like '%,sheath--'||cable_seq_id  or Column1='sheath--'||cable_seq_id) order by seq_no desc limit 1 ;

****************************************************************

We have created an index on parental_path Column1 still it is taking 4secs to get the results.

Could you please suggest a better way to execute the query.

Thanks for your support.

Regards,
PostgAnn.

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux