sql_runtime in sysmaster:syssqltrace

Posted in 2019

RUEDIGER PAPKE — Wed, 06 Feb 2019 16:32:25 — source: IIUG Forums & Mailing Lists

I am making some test for logging long running statements. very simple sql: informix$ time echo 'set pdqpriority 0; select count(*) from \\\\ systables,syscolumns,sysindexes' | dbaccess stores Database selected. PDQ Priority set. (count(*)) 7106352 1 row(s) retrieved. Database closed. real 0m3.035s user 0m0.001s sys 0m0.008s CLOCK TIME 3.035s select sql_runtime from sysmaster:syssqltrace showssql_runtime 5,219337099557 I am confused !!! There is no parallel work. Why is sql_runtime much longer than real time ??? Any explanation ??? TIA ruediger

↪ replying to RUEDIGER PAPKE

RUEDIGER PAPKE — Wed, 06 Feb 2019 16:37:29 — source: IIUG Forums & Mailing Lists

sorry I've forgotten to show versions: informix@FA-SLES12-01:~/TRACE2> onstat - IBM Informix Dynamic Server Version 12.10.FC12TL -- On-Line -- Up 1 days 07:21:45 -- 8357888 Kbytes informix@FA-SLES12-01:~/TRACE2> uname -a Linux FA-SLES12-01 4.4.103-6.38-default #1 SMP Mon Dec 25 20:44:33 UTC 2017 (e4b9067) x86_64 x86_64 x86_64 GNU/Linux

Glossary

dbaccess