How to generate slow query report Like Pg_badger analysis on Azure postgres Flexible server

Mani Mahesh Sivakumar 56

Hi team,

We have a requirement of catching and analyzing slow running queries in Azure postgres flexible server. We are trying to use Pgbadger (parsing tool) for analyzing the slow queries through logs. Is there any inbuilt azure tool for analyzing and finding out slow queries? Otherwise kindly suggest a way to generate pg_badger report in azure flexible server

Thanks and regards,

Manimahesh S

GeethaThatipatri-MSFT 29,387 Reputation points Microsoft Employee

2023-02-14T21:39:51.85+00:00

@Mani Mahesh Sivakumar Thanks for posting your question in the Microsoft Q&A forum.

You can find slow queries after the fact using pg_qs/ iperf but not while you are executing. You can use pg_stat_activity to find currently slow-running queries.

Are you trying to catch them during or after?

Regards

Geetha
Oury Ba-MSFT 19,176 Reputation points Microsoft Employee

2023-02-21T17:59:59.8833333+00:00

@Mani Mahesh Sivakumar Please do not forget to mark as accept answer if the reply was helpful.

Regards,

Oury

3 answers

Mani Mahesh Sivakumar 56 Reputation points

2023-02-15T03:39:38.3533333+00:00

@GeethaThatipatri-MSFT

Yes I want to view slow queries for past day only. Can you share steps to use pg_qs/ iperf. Whether we can generate report of slow and blocking queries using that tool.

Kindly help

Thanks and regards,

Manimahesh S
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
GeethaThatipatri-MSFT 29,387 Reputation points Microsoft Employee

2023-02-15T21:58:59.3033333+00:00

@Mani Mahesh Sivakumar Thanks for the information,

You can follow the steps provided in this document

Regards

Geetha
Please sign in to rate this answer.
GeethaThatipatri-MSFT 29,387 Reputation points Microsoft Employee

2023-02-17T16:00:24.68+00:00

@Mani Mahesh Sivakumar We haven't heard back from you. Just wanted to check if you had the chance to check my response.

Regards

Geetha

GeethaThatipatri-MSFT 29,387 Reputation points Microsoft Employee

2023-02-22T18:36:30.3066667+00:00

@Mani Mahesh Sivakumar if you still have issues with the provided steps from the document then please do send us an email so we can better assist you.

Regarsd

Geetha
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
Alicja Kucharczyk 0 Reputation points

2023-04-21T09:06:06.38+00:00

Please find the instructions up here: https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/how-to-generate-pgbadger-report-from-azure-database-for/ba-p/3756328
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

How to generate slow query report Like Pg_badger analysis on Azure postgres Flexible server

3 answers

Your answer