From the “Home” screen and the left menu, you can access your instances under the “My Services” link. You can either access ALL of them or address individually the Development / Staging and Production instances.
When displaying the list of instances, the main information is available, including the instance name, price and status. Click on the Arrow button. The “PostgreSQL” tab is available at the bottom of the screen.
One click on the “CHECK RUNNING QUERY” button shall output a list of the running PostgreSQL queries on the instance in real-time.
Sometimes, given the volume of the activity and ongoing transactions, the output will be quite big. As you can see in the above example, there are 13 pages of 10 statements. A good way to isolate a specific statement can be to parse these results with a specific key-word or expression.
In this example, we are filtering with the key expression “mail,” and the results are automatically narrowed down to one unique result.
NB: This feature can be particularly useful for troubleshooting performance issues or excessive response times related to specific codes or actions.