Overview

If you are finding the speed of your Spatial Data Warehouse (SDW) slow or maybe you cannot open SDW tables, then the following steps could help resolve the problem.

Step-by-step guide

You could simply restart the Windows Service or reboot the Server itself or you can try to identify the session that is causing the problem.

• Log onto your SDW using pgAdmin and connect to the database as the Posgres user.
• Run the following SQL which will list all of the current running sessions.
  
  

SELECT procpid, age(clock_timestamp(), query_start), usename, current_query FROM pg_stat_activity WHERE current_query != '<IDLE>'
AND current_query NOT ILIKE '%pg_stat_activity%' ORDER BY query_start desc;

• You can cancel the running session using the following SQL where procpid is the procpid value for the session from the previous query.
  
  

SELECT pg_cancel_backend(procpid);