Document and hold training on how to identify slowest queries in realtime (and historical) in Aurora

[lbeaufort]

User Story:
As a production monitor, it makes it easier for me to identify performance issues if I can see the slowest running queries in the database in realtime.

We can see historical (previous day and before) slow queries in the database using PGBadger, but in Aurora we're not sure how to see the slowest running queries in realtime.

Database team will conduct a training to show interested parties on how to do this.

I think @rjayasekera has a support ticket in for this. This is a topic was takeaway from the metrics meeting.

Completion criteria:

• Document how to do this realtime investigation into slow queries
• Hold training with team on how to do historical and realtime analysis. Share documentation with team.

[dzhang-fec]

Please review the attached Presentation with demo and samples.
image

HowToFindSlowSqlInAurora.pptx

[dzhang-fec]

I have created PPT ^ and ready to show demo per @jonella yesterday. Whenever is good to the teams. Thanks

[dzhang-fec]

Finished the training yesterday 11:00am and did followup per request at the #dev. close. thanks for @JonellaCulmer 's help.