From onstat -g ses:
Current SQL statement (2) :
SELECT thingid, projectedclip(series, GETNEXTVALID(series,
?::datetime
year to fraction(5)).ts, ?::datetime year to fraction(5), 0,
'r06')::timeseries(row(ts datetime year to fraction(5), r06
smallfloat))FROM Interfaces WHERE GETNEXTVALID(series,
?::datetime year
to fraction(5)).ts IS NOT NULL AND thingid IN
(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?
,?,?,?,?,?,
?,?,?,?,?,?,?,?,?,?,?,?,?)
Host variables :
address type flags value
-----------------------------------------
0x00000000468cc038 DTIME 0x000 2011-01-07 21:36:32.99900
0x00000000468cc0c8 DTIME 0x000 2015-10-08 19:12:24.00000
0x00000000468cc158 DTIME 0x000 2011-01-07 21:36:32.99900
0x00000000468cc1e8 SERIAL8 0x000 711
0x00000000468cc278 SERIAL8 0x000 712
0x00000000468cc308 SERIAL8 0x000 713
0x00000000468cc398 SERIAL8 0x000 714
0x00000000468cc428 SERIAL8 0x000 715
0x00000000468cc4b8 SERIAL8 0x000 716
0x00000000468cc548 SERIAL8 0x000 717
0x00000000468cc5d8 SERIAL8 0x000 718
0x00000000468cc668 SERIAL8 0x000 719
0x00000000468cc6f8 SERIAL8 0x000 720
0x00000000468cc788 SERIAL8 0x000 721
0x00000000468cc818 SERIAL8 0x000 722
0x00000000468cc8a8 SERIAL8 0x000 723
0x00000000468cc938 SERIAL8 0x000 724
0x00000000468cc9c8 SERIAL8 0x000 725
0x00000000468cca58 SERIAL8 0x000 726
0x00000000468ccae8 SERIAL8 0x000 727
0x00000000468ccb78 SERIAL8 0x000 728
0x00000000468ccc08 SERIAL8 0x000 729
0x00000000468ccc98 SERIAL8 0x000 730
0x00000000468ccd28 SERIAL8 0x000 731
0x00000000468ccdb8 SERIAL8 0x000 732
0x00000000468cce48 SERIAL8 0x000 733
0x00000000468cced8 SERIAL8 0x000 734
0x00000000468ccf68 SERIAL8 0x000 735
0x00000000468ccff8 SERIAL8 0x000 736
0x00000000468cd088 SERIAL8 0x000 737
0x00000000468cd118 SERIAL8 0x000 738
0x00000000468cd1a8 SERIAL8 0x000 739
0x00000000468cd238 SERIAL8 0x000 740
0x00000000468cd2c8 SERIAL8 0x000 741
0x00000000468cd358 SERIAL8 0x000 742
0x00000000468cd3e8 SERIAL8 0x000 743
0x00000000468cd478 SERIAL8 0x000 744
0x00000000468cd508 SERIAL8 0x000 745
0x00000000468cd598 SERIAL8 0x000 746
0x00000000468cd628 SERIAL8 0x000 747
0x00000000468cd6b8 SERIAL8 0x000 748
0x00000000468cd748 SERIAL8 0x000 749
0x00000000468cd7d8 SERIAL8 0x000 750
0x00000000468cd868 SERIAL8 0x000 751
0x00000000468cd8f8 SERIAL8 0x000 752
0x00000000468cd988 SERIAL8 0x000 753
0x00000000468cda18 SERIAL8 0x000 754
0x00000000468cdaa8 SERIAL8 0x000 755
0x00000000468cdb38 SERIAL8 0x000 756
0x00000000468cdbc8 SERIAL8 0x000 757
0x00000000468cdc58 SERIAL8 0x000 758
0x00000000468cdce8 SERIAL8 0x000 759
0x00000000468cdd78 SERIAL8 0x000 760
Pool Summary:
name class addr totalsize freesize
#allocfrag #freefrag
EXE.33.62 V 468b8040 5183598592 56702848
20840 20794 |
