Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
On 16 Sep., 07:28, mohitanch...@gmail.com wrote:
> Version: IDS 10
>
> I just have a small question: Does informix stores the query execution
> time, user who executed it etc. somewhere or something that gives some
> Warnings about queries that are really bad. I was thinking if there is
> any easy way to find out about query statistics without having to put
> set explain on and some kind of debugging around the queries. It would> help a lot where there are thousands of queries in a complex
> application.
>
> I am sure what I am asking for is not relevant for informix to store
> because onus lies on the application developer, still I thought I'll
> ask.
Hi,
have you heard about the SQLSTATS client environment variable?
SQLSTATS=1 -> will record frequency in
sysmaster:syssqexplain.sqx_executions
SQLSTATS=2 -> will record frequency and cumulated time for the
query in table mentioned above.
Works good for preprared statements.
Best regards
Stefan
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.