Measuring sql queries executed remotely

Hi there:

I’d like to know if any of the Percona’s products could be useful to tackle the problem I’m facing to with my PostgreSQL database.

My necessity is about measuring the time some custom sql queries take to be executed on a remote-server-hosted PostgreSQL database. I could launch these sql queries from an ad-hoc Java program running on my PC and then measure the time invested to be done, but I think these measured times could be biased due to the network traffic. This’s why I’d be interested in measuring these times on the server side directly.

It’s in that scenario where I wonder if some of the Percona’s products could be useful to carry on the test I want to do.

Any help or clarification will be really appreciate. Thanks in advance.

1 Like

Are you using vanilla PostgreSQL or Percona PostgreSQL Distribution (PPD)?

If you are using PPD, you might want to explore pg_stat_monitor extension that’s contained in the package. That is if you have the requisite permissions to create an extension.

You see pg_stat_monitor in more detail on our github.

1 Like

Hi @txapeldot
Percona has written software to address this very need you have - it is called Percona Monitoring and Management, and fully supports PostgreSQL and in fact leverages pg_stat_monitor .
https://www.percona.com/doc/percona-monitoring-and-management/2.x/setting-up/client/postgresql.html
In particular look at the Query Analytics component for query performance metrics. Let us know if this meets your needs!

1 Like