|
|
|
Returns FairCom DB SQL current SQL subsystem statistics.
Result Set Fields (2)
Description VARCHAR(64)
Value BIGINT
Example
>call fc_get_sqlstats();
DESCRIPTION VALUE
----------- -----
SQL memory highwater 2908764
current aggregate sum 2507391
current net SQL memory allocations 1884
dynamic statement cache requests 59
dynamic statement cache hits 44
static statement cache requests 36
static statement cache hits 26
current dynamic stmt cache entries 13
highest dynamic stmt cache entries 14
maximum dynamic stmt cache entries 150
current static stmt cache entries 10
highest static stmt cache entries 10
maximum static stmt cache entries 150
current number of dynamic caches 1
current number of static caches 1
current number of local caches 1
current local stmt cache entries 0
highest local stmt cache entries 0
maximum local stmt cache entries 150
local statement cache requests 0
local statement cache hits 0
Tuple fetches by index only scan 0
Tuple fetches by index scan with record retrieval 76
23 records returned
