Purpose
During analysis or snapshots, some steps take too much time or are stuck.
It is possible to monitor the Server Status to watch which stored procedure or query is currently running, by using PgAdmin (connect to the server > Click on Tools > Server status), but this option will not show systematically all queries that are launched.
In that case, we can log all queries that are running in PostgreSQL by proceeding as described below
Applicable Platform or <Sub Platform Version>
Platform or <Sub Platform Version> | Yes/No |
|---|---|
Details
To log all queries that are running in PostgreSQL by proceed as follows
- Stop the Cast Storage Service.
- In your C:\Program Files\CAST\CASTStorageService2\db_data\postgresql.conf file, change the log_statement setting to 'all'
- Restart the Cast Storage Service
- Restart postgres service and run the analysis / snapshot / process again
Notes/comments
Related Pages
