Hi, It seems that in older version of PSQL there has been a possibity to see all SQL queries getting into the database. Problem is that I have tens of clients accessing the database and now I would like to see what kind of queries they are using. We have having some kind of performance issues and I would like to see from query analyzer that for example are indexes properly used etc. I have tried to use registry settings told somewhere else but I just can't get the QPF file. And I'm using PSQL 9.1 at the moment... Thanks in advance for any help on this! :) Timo

 The registry settings for the Query Plan Viewer are the same in PSQL 2000, v8, v9, and v10.  One thing to note is that in v9 and later, the PCC does not use ODBC.  It uses JDBC.  Query Plan Viewer (and it's registry settings) uses an Engine Interface DSN. 

I think that our code is using ODBC in a way that this Pervasive can't see it, probably using file DSN?. I installed Wireshark (previously Ethereal) and I used that to trace all SQL calls coming into the port TCP/1583 and having text SELECT in them. It was actually quite easy to use so at least I can recommend that.