Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Try to generate the report in both customer and training server for comparison. As for example, the report generation in customer server is more than 5 minutes and in training server is less than 1 minutes.

  2. Check the indexing and if there is any duplicate index. :

    1. /wiki/spaces/WM/pages/809205990

    2. /wiki/spaces/WM/pages/1189904385

  3. If everything was indexed and no duplicate index, run analyze verbose and vacuum full on the customer database. It is recommended to do this at night after no user is using the server.

    Code Block
    analyze verbose; vacuum full;

4. After finished (if it took too long, please kill the query from from running query before the server is accessed in the morning), try generate the report and compared the generation time to before the query is run.

Video briefing:

https://drive.google.com/file/d/1suw0wN3GRDqDpsxO1NE_5IfLSfrfpvrn/view?usp=sharing

https://drive.google.com/file/d/1k-LsFryWMoioxYnS8TL5yI6ISnDh_Jy6/view?usp=sharing