How do I see what queries are running on an interbase database

Question

I have a Interbase 7.x database being used by an application.

I want to know which queries are run by that application in different scenarios.

Does anyone know about how to "profile" an interbase database and see which queries are currently running?

Answer 1

Use InterBase Performance Monitor. It's built into IBConsole, or you can get a standalone version.

Alternately:

SELECT * FROM TMP$STATEMENTS;

Answer 2

IBExpert includes a Interbase Proxy Service which can be used to log all SQL statements: instead of connecting with the Interbase server, all client applications use the proxy address. This will make the Proxy a bottleneck but it has the advantage that every statement will be captured and logged.