SELECT COUNT(*) FROM CURV_VERSIONS;

PLAN (CURV_VERSIONS NATURAL)

       COUNT 
============ 
    22733063 

Current memory = 8435825808
Delta memory = 37104
Max memory = 8544542928
Elapsed time= 2442.59 sec
Buffers = 1000000
Reads = 4129105
Writes 5811
Fetches = 63521418

SELECT COUNT(*) FROM VIEW_CURVE;

PLAN JOIN (MERGE (SORT (JOIN (JOIN (JOIN (JOIN (JOIN (JOIN (JOIN (JOIN (VIEW_CURVE LV F NATURAL, VIEW_CURVE LV L1 INDEX (PK_LEVELS_ID), VIEW_CURVE LV LT1 INDEX (PK_LEVELTYPES_TYPEV)), JOIN (VIEW_CURVE LV L2 INDEX (PK_LEVELS_ID), VIEW_CURVE LV LT2 INDEX (PK_LEVELTYPES_TYPEV))), JOIN (VIEW_CURVE LV L3 INDEX (PK_LEVELS_ID), VIEW_CURVE LV LT3 INDEX (PK_LEVELTYPES_TYPEV))), JOIN (VIEW_CURVE LV L4 INDEX (PK_LEVELS_ID), VIEW_CURVE LV LT4 INDEX (PK_LEVELTYPES_TYPEV))), JOIN (VIEW_CURVE LV L5 INDEX (PK_LEVELS_ID), VIEW_CURVE LV LT5 INDEX (PK_LEVELTYPES_TYPEV))), JOIN (VIEW_CURVE LV L6 INDEX (PK_LEVELS_ID), VIEW_CURVE LV LT6 INDEX (PK_LEVELTYPES_TYPEV))), JOIN (VIEW_CURVE LV L7 INDEX (PK_LEVELS_ID), VIEW_CURVE LV LT7 INDEX (PK_LEVELTYPES_TYPEV))), JOIN (VIEW_CURVE LV L8 INDEX (PK_LEVELS_ID), VIEW_CURVE LV LT8 INDEX (PK_LEVELTYPES_TYPEV)))), SORT (JOIN (JOIN (JOIN (VIEW_CURVE CN NATURAL, VIEW_CURVE CV INDEX (FK_CURVVERSIONS_NAMEID)), VIEW_CURVE CC INDEX (PK_CURVCOMMENTS_ID)), VIEW_CURVE U INDEX (PK_UNITS_ID)))), VIEW_CURVE DB INDEX (PK_WSDATABASE_ID))

       COUNT 
============ 
    22723272 

Current memory = 8436037600
Delta memory = 211792
Max memory = 8544542928
Elapsed time= 5015.62 sec
Buffers = 1000000
Reads = 4608871
Writes 25225
Fetches = 389290619

create table curv_versions(
	id         integer not null,
	name_id    integer not null,
	usrname_id integer,
	id_row     integer not null,
	int_top    integer not null,
	int_bottom integer not null,
	int_step   integer not null,
	n_vers     varchar(64),
	unit_id    integer,

	f_id       integer not null,
	t_name_id  integer not null,
	qmark      integer,
	mainfamily integer,
	subfamily  integer,
	ufi        bigint,
	comment_id integer,

	minv       float,
	maxv       float,

	c_guid     varchar(64),

	last_modified timestamp,

	constraint u_curve_vers             unique      (name_id, id_row, n_vers),
	constraint pk_curv_versions_id      primary key (id),
	constraint fk_curv_versions_id_row  foreign key (id_row)     references table_rows    (id) on delete cascade,
	constraint fk_curv_versions_name_id foreign key (name_id)    references curve_names   (id),
	constraint fk_curv_versions_usrname foreign key (usrname_id) references usrcurve_names(id),
	constraint fk_curv_versions_f_id    foreign key (f_id)       references files         (id),
	constraint fk_curv_versions_tni     foreign key (t_name_id)  references table_names   (id),
	constraint fk_curv_versions_uid     foreign key (unit_id)    references units         (id),
	constraint fk_curv_versions_cid     foreign key (comment_id) references curv_comments (id)
);

create index idx_curv_versions_n_f  on curv_versions(name_id,f_id);
create index idx_curv_versions_cg  on curv_versions(c_guid);

set FBPATH=C:\Program Files\Firebird\Firebird_2_5\bin
set FBPATH=%FBPATH%;C:\Program Files (x86)\Firebird\Firebird_2_5\bin
set FBPATH=%FBPATH%;D:\Program Files\Firebird\Firebird_2_5\bin
set FBPATH=%FBPATH%;D:\Program Files (x86)\Firebird\Firebird_2_5\bin

set path=%FBPATH%\bin;%path%

set LogsDir="%~dp0..\logs\stat"
set DbFile=%~dp0..\db\prime.fbdb

set LogFile=%date%.log
set LogFile=%LogFile:\=.%
set LogFile=%LogFile:/=.%
set LogFile=%LogFile:,=.%
set LogFile=%LogsDir%\info-%LogFile%
md "%LogsDir%"

@echo.==================== System Information ==================== >"%LogFile%"
ver >>"%LogFile%"
@echo.>>"%LogFile%"
systeminfo >>"%LogFile%"

@echo.>>"%LogFile%"
@echo.==================== Active Tasks ==================== >>"%LogFile%"
tasklist /V >>"%LogFile%"

@echo.>>"%LogFile%"
@echo.==================== Firebird Server Configuration ==================== >>"%LogFile%"
for %%A in ("%FBPATH:;=";"%") do type "%%~A\..\firebird.conf" >>"%LogFile%"

@echo.>>"%LogFile%"
@echo.==================== gstat -h ==================== >>"%LogFile%"
gstat -h "%DbFile%" -user SYSDBA -pass %PWD% >>"%LogFile%"

@echo.==================== gstat -a -r ==================== >>"%LogFile%"
gstat -a -r "%DbFile%" -user SYSDBA -pass %PWD% >>"%LogFile%"