Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 10.03.2021 16:29
Common Performance Final Results
  1. Hardware and OS info
  2. Test configuration
  3. Test Finish details
  4. Test workload details
  5. Indices DDL for heavy-loaded table(s)
  1. Performance, TOTAL score:    as table     as chart
  2. Performance per MINUTE, during test_time phase:    as table     as chart
  3. Performance, DETAILS per units
  4. Memory consumption, metadata cache, attachments activity    as table    as chart
  5. Monitoring data: STATEMENTS activity, as chart
  6. Exceptions during test run
  1. mon$database and 'show version' results
  2. Database statistics was not gathered. Change config parameter 'run_db_statistics' to 1.
  3. Database validation was not performed. Change config parameter 'run_db_validation' to 1.
  4. New in firebird.log while test was run
  5. Final processing of ISQL logs

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID df9f488d08424df294c459d6c283e9c3
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-03-04 16:07
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.26
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17531048 kB
MemAvailable 31627480 kB
Buffers 0 kB
Cached 14176240 kB
SwapCached 0 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

SERVER_MODE                     SuperServer 3.0.8
DB_NAME                         /home/bases/oltp30-etalone.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    1000000
PAGE_SIZE                       8192


Test configuration settings

param=actions_todo_before_reconnect, val=300
param=create_with_compound_columns_order, val=most_selective_first
param=create_with_debug_objects, val=1
param=create_with_fw, val=sync
param=create_with_separate_qdistr_idx, val=0
param=create_with_split_heavy_tabs, val=1
param=create_with_sweep, val=0
param=dbnm, val=/home/bases/oltp30-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp30-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb30/bin
param=file_name_this_host_info, val=bz_cpu24_ram32
param=file_name_with_test_params, val=regular
param=gather_hardware_info, val=1
param=halt_test_on_errors, val=/CK/
param=host, val=localhost
param=init_buff, val=10000
param=init_docs, val=0
param=is_embed, val=0
param=make_html, val=1
param=max_cps, val=25
param=mon_query_interval, val=60
param=mon_query_role, val=tmp$oemul$worker
param=mon_unit_list, val=//
param=mon_unit_perf, val=2
param=mon_usr_prefix, val=tmp$oemul$user_
param=no_auto_undo, val=1
param=port, val=3333
param=pwd, val=masterkey
param=qmism_verify_bitset, val=1
param=recalc_idx_min_interval, val=30
param=remove_isql_logs, val=if_no_severe_errors
param=replace_instance, val=1
param=report_compress_cmd, val=/usr/bin/7za
param=results_storage_fbk, val=/home/bases/oltp30-results-storage.fbk
param=run_db_statistics, val=0
param=run_db_validation, val=0
param=separate_workers, val=1
param=sleep_ddl, val=./oltp_sleepUDF_nix.sql
param=sleep_max, val=0
param=test_intervals, val=60
param=test_time, val=120
param=tmpdir, val=/var/tmp/logs-oltp30
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=used_in_replication, val=0
param=use_mtee, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=1
param=wait_if_not_exists, val=0
param=warm_time, val=30
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-03-10 16:27:20
DTS_END                         2021-03-10 16:27:20.5040
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/39996
TRN_ID                          234582
ATT_ID                          707
EXC_UNIT                        2


Test workload details

SETTING_NAME SETTING_VALUE
WORKING_MODE SMALL_03
C_WARES_MAX_ID 400
C_CUSTOMER_DOC_MAX_ROWS 10
C_SUPPLIER_DOC_MAX_ROWS 50
C_CUSTOMER_DOC_MAX_QTY 15
C_SUPPLIER_DOC_MAX_QTY 50
C_NUMBER_OF_AGENTS 50

Indexes for heavy-loaded tables

TAB_NAME IDX_NAME IDX_KEY
XQD_1000_1200 XQD_1000_1200_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_ASC WORKER_ID,DOC_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_DEC WORKER_ID,DOC_ID
XQD_1200_2000 XQD_1200_2000_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2000_3300 XQD_2000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2100_3300 XQD_2100_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_3300_3400 XQD_3300_3400_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID

Performance in TOTAL

ACTION AVG_TIMES_PER_MINUTE AVG_ELAPSED_MS SUCCESSFUL_TIMES_DONE
*** OVERALL *** for 120 minutes: 9153.83 20746 1098459
customer order: creation 170.83 351 20500
customer order: refuse 14.19 372 1703
order to supplier: creation 45.48 1333 5458
order to supplier: removal 3.48 104519 417
invoice (draft): creation 45.37 3197 5444
invoice (draft): removal 52.07 768 6248
invoice accept: apply 41.29 18337 4955
invoice accept: cancel 46.93 795 5631
customer reserve: creation 3820.48 182 458457
customer reserve: removal 4624.97 63 554996
realization accept: apply 83.59 183 10031
realization accept: cancel 77.10 106 9252
payment from customer: creation 57.83 114 6939
payment from customer: removal 5.60 76 672
payment to supplier: creation 49.21 126 5905
payment to supplier: removal 3.33 85 400
service: total inventory turnovers 4.89 1218 587
service: total monetary turnovers 6.23 34 747
service: aggregate perf. data 0.94 18521 113
service: refresh index statistics 0.03 264547 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 10-03-2021 16:29:23 to 10-03-2021 16:29:25.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1906
TEST_TIME 2 4456
TEST_TIME 3 4517
TEST_TIME 4 5454
TEST_TIME 5 5221
TEST_TIME 6 5959
TEST_TIME 7 6234
TEST_TIME 8 6288
TEST_TIME 9 6529
TEST_TIME 10 6598
TEST_TIME 11 6540
TEST_TIME 12 7010
TEST_TIME 13 6961
TEST_TIME 14 6938
TEST_TIME 15 7219
TEST_TIME 16 7530
TEST_TIME 17 8021
TEST_TIME 18 8198
TEST_TIME 19 8497
TEST_TIME 20 8456
TEST_TIME 21 8775
TEST_TIME 22 8815
TEST_TIME 23 9353
TEST_TIME 24 9740
TEST_TIME 25 9779
TEST_TIME 26 10506
TEST_TIME 27 10748
TEST_TIME 28 10694
TEST_TIME 29 11103
TEST_TIME 30 11548
TEST_TIME 31 11384
TEST_TIME 32 11256
TEST_TIME 33 11056
TEST_TIME 34 10741
TEST_TIME 35 10604
TEST_TIME 36 10549
TEST_TIME 37 10439
TEST_TIME 38 10268
TEST_TIME 39 10302
TEST_TIME 40 10172
TEST_TIME 41 10123
TEST_TIME 42 9954
TEST_TIME 43 9849
TEST_TIME 44 9805
TEST_TIME 45 9802
TEST_TIME 46 9758
TEST_TIME 47 9780
TEST_TIME 48 9778
TEST_TIME 49 9751
TEST_TIME 50 9647
TEST_TIME 51 9637
TEST_TIME 52 9613
TEST_TIME 53 9661
TEST_TIME 54 9681
TEST_TIME 55 9766
TEST_TIME 56 9740
TEST_TIME 57 9691
TEST_TIME 58 9790
TEST_TIME 59 9786
TEST_TIME 60 9790
TEST_TIME 61 9799
TEST_TIME 62 9833
TEST_TIME 63 9831
TEST_TIME 64 9787
TEST_TIME 65 9687
TEST_TIME 66 9628
TEST_TIME 67 9554
TEST_TIME 68 9485
TEST_TIME 69 9507
TEST_TIME 70 9440
TEST_TIME 71 9481
TEST_TIME 72 9430
TEST_TIME 73 9340
TEST_TIME 74 9363
TEST_TIME 75 9400
TEST_TIME 76 9404
TEST_TIME 77 9365
TEST_TIME 78 9370
TEST_TIME 79 9408
TEST_TIME 80 9437
TEST_TIME 81 9408
TEST_TIME 82 9424
TEST_TIME 83 9496
TEST_TIME 84 9479
TEST_TIME 85 9477
TEST_TIME 86 9534
TEST_TIME 87 9690
TEST_TIME 88 9608
TEST_TIME 89 9509
TEST_TIME 90 9487
TEST_TIME 91 9437
TEST_TIME 92 9379
TEST_TIME 93 9362
TEST_TIME 94 9346
TEST_TIME 95 9320
TEST_TIME 96 9303
TEST_TIME 97 9296
TEST_TIME 98 9408
TEST_TIME 99 9383
TEST_TIME 100 9450
TEST_TIME 101 9411
TEST_TIME 102 9385
TEST_TIME 103 9426
TEST_TIME 104 9483
TEST_TIME 105 9435
TEST_TIME 106 9472
TEST_TIME 107 9528
TEST_TIME 108 9517
TEST_TIME 109 9532
TEST_TIME 110 9468
TEST_TIME 111 9440
TEST_TIME 112 9433
TEST_TIME 113 9399
TEST_TIME 114 9364
TEST_TIME 115 9328
TEST_TIME 116 9281
TEST_TIME 117 9275
TEST_TIME 118 9218
TEST_TIME 119 9183
TEST_TIME 120 9156

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 10-03-2021 16:29:26 to 10-03-2021 16:29:30.

Performance in DETAILS

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL CNT_USER_EXC
doc_list_aiud 1523415 1523415 0 0.00 0 26333 6 0 0
doc_list_biud 1523415 1523415 0 0.00 0 43261 29 0 0
sp_add_invoice_to_stock 5149 4955 194 3.76 28 206496 18338 0 194
sp_cancel_adding_invoice 5631 5631 0 0.00 5 91380 795 0 0
sp_cancel_client_order 1703 1703 0 0.00 4 15427 373 0 0
sp_cancel_customer_reserve 554996 554996 0 0.00 1 43264 63 0 0
sp_cancel_pay_from_customer 672 672 0 0.00 3 5834 77 0 0
sp_cancel_pay_to_supplier 400 400 0 0.00 3 6441 86 0 0
sp_cancel_supplier_invoice 6260 6248 12 0.19 2 21412 769 0 12
sp_cancel_supplier_order 417 417 0 0.00 11 999192 104520 0 0
sp_cancel_write_off 9252 9252 0 0.00 1 12112 106 0 0
sp_client_order 20500 20500 0 0.00 3 42863 351 0 0
sp_customer_reserve 458457 458457 0 0.00 0 83341 183 0 0
sp_fill_shopping_cart 31399 31399 0 0.00 1 10417 33 0 0
sp_fill_shopping_cart_clo_res 458452 458452 0 0.00 0 13938 13 0 0
sp_get_clo_for_invoice 4950 4950 0 0.00 0 18016 261 0 0
sp_kill_cost_storno 15955 15955 0 0.00 0 22766 53 0 0
sp_kill_qstorno_ret_qs2qd 1125909 1125909 0 0.00 0 43256 34 0 0
sp_kill_qty_storno 593228 593228 0 0.00 0 43261 73 0 0
sp_lock_selected_doc 20618 20618 0 0.00 0 7340 6 0 0
sp_make_cost_storno 27825 27825 0 0.00 0 16252 47 0 0
sp_multiply_rows_for_pdistr 27825 27825 0 0.00 0 6133 25 0 0
sp_multiply_rows_for_qdistr 20500 20500 0 0.00 0 42854 170 0 0
sp_pay_from_customer 6939 6939 0 0.00 4 15941 115 0 0
sp_pay_to_supplier 5905 5905 0 0.00 5 26285 127 0 0
sp_payment_common 12844 12844 0 0.00 1 26255 33 0 0
sp_qd_handle_on_cancel_clo 1703 1703 0 0.00 0 10139 330 0 0
sp_qd_handle_on_invoice_upd_sts 10581 10581 0 0.00 0 25556 331 0 0
sp_qd_handle_on_reserve_upd_sts 10031 10031 0 0.00 0 28982 70 0 0
sp_reserve_write_off 10031 10031 0 0.00 6 28997 183 0 0
sp_supplier_invoice 5444 5444 0 0.00 6 96040 3197 0 0
sp_supplier_order 5458 5458 0 0.00 5 43476 1333 0 0
srv_aggregate_perf_data 113 113 0 0.00 2740 280438 18521 0 0
srv_fill_mon_cache_memory 164 164 0 0.00 1579 158424 32788 0 0
srv_find_qd_qs_mism 1051366 1051366 0 0.00 0 26332 5 0 0
srv_make_invnt_saldo 587 587 0 0.00 24 98477 1218 0 0
srv_make_money_saldo 747 747 0 0.00 1 7386 34 0 0
srv_recalc_idx_stat 4 4 0 0.00 145754 433378 264548 0 0
t$perf-abend:sp_add_invoice_to_stock 194 194 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 12 12 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4955 4955 0 0.00 0 7557 144 0 0
t$perf-norm:sp_cancel_adding_invoice 357 357 0 0.00 0 1752 79 0 0
t$perf-norm:sp_cancel_client_order 1703 1703 0 0.00 0 3931 14 0 0
t$perf-norm:sp_cancel_customer_reserve 716 716 0 0.00 0 3883 21 0 0
t$perf-norm:sp_cancel_pay_from_customer 672 672 0 0.00 0 2389 7 0 0
t$perf-norm:sp_cancel_pay_to_supplier 400 400 0 0.00 0 1782 11 0 0
t$perf-norm:sp_cancel_supplier_invoice 374 374 0 0.00 0 894 13 0 0
t$perf-norm:sp_cancel_supplier_order 417 417 0 0.00 0 24671 1478 0 0
t$perf-norm:sp_cancel_write_off 1002 1002 0 0.00 0 1390 7 0 0
t$perf-norm:sp_client_order 20500 20500 0 0.00 0 4976 14 0 0
t$perf-norm:sp_customer_reserve 987 987 0 0.00 0 2546 6 0 0
t$perf-norm:sp_pay_from_customer 6939 6939 0 0.00 0 6948 9 0 0
t$perf-norm:sp_pay_to_supplier 5905 5905 0 0.00 0 3889 11 0 0
t$perf-norm:sp_reserve_write_off 10031 10031 0 0.00 0 5514 11 0 0
t$perf-norm:sp_supplier_invoice 5444 5444 0 0.00 0 9852 17 0 0
t$perf-norm:sp_supplier_order 5459 5459 0 0.00 0 2881 14 0 0
t$perf-norm:srv_aggregate_perf_data 113 113 0 0.00 0 4109 37 0 0
t$perf-norm:srv_fill_mon_cache_memory 164 164 0 0.00 0 2299 22 0 0
t$perf-norm:srv_make_invnt_saldo 587 587 0 0.00 0 901 16 0 0
t$perf-norm:srv_make_money_saldo 747 747 0 0.00 0 1238 12 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 35 11 0 0
v_add_invoice_to_stock 10280 9892 388 3.77 0 10690 21 0 388
v_all_customers 37362 37362 0 0.00 0 20 1 0 0
v_all_suppliers 30530 30530 0 0.00 0 105 1 0 0
v_all_wares 41000 41000 0 0.00 0 17 1 0 0
v_cancel_adding_invoice 714 714 0 0.00 0 317 6 0 0
v_cancel_client_order 3406 3406 0 0.00 0 14750 8 0 0
v_cancel_customer_prepayment 1344 1344 0 0.00 0 5822 8 0 0
v_cancel_customer_reserve 1432 1432 0 0.00 0 946 3 0 0
v_cancel_payment_to_supplier 800 800 0 0.00 0 1619 10 0 0
v_cancel_supplier_invoice 772 748 24 3.10 0 1840 17 0 24
v_cancel_supplier_order 834 834 0 0.00 0 5345 19 0 0
v_cancel_write_off 2004 2004 0 0.00 0 1582 13 0 0
v_max_id_clo_ord 5457 5457 0 0.00 0 258 1 0 0
v_max_id_clo_res 987 987 0 0.00 0 2211 14 0 0
v_max_id_ord_sup 5442 5442 0 0.00 0 3106 2 0 0
v_max_non_paid_invoice 1539 1539 0 0.00 0 556 2 0 0
v_max_non_paid_realizn 3698 3698 0 0.00 0 4890 4 0 0
v_min_id_clo_ord 5457 5457 0 0.00 0 3470 5 0 0
v_min_id_clo_res 987 987 0 0.00 0 1604 3 0 0
v_min_id_ord_sup 5442 5442 0 0.00 0 5207 7 0 0
v_min_non_paid_invoice 5905 5905 0 0.00 0 26251 19 0 0
v_min_non_paid_realizn 6939 6939 0 0.00 0 9741 23 0 0
v_our_firm 10120 10120 0 0.00 0 28 1 0 0
v_reserve_write_off 20062 20062 0 0.00 0 16098 10 0 0
x_lock_depdocs_on_canc_invoice 11505 11505 0 0.00 0 16885 125 0 0
x_lock_depdocs_on_canc_sup_ord 417 417 0 0.00 0 17335 404 0 0
x_make_qstorno_1000_1200 5458 5458 0 0.00 1 43458 1255 0 0
x_make_qstorno_1200_2000 5444 5444 0 0.00 3 95692 3087 0 0
x_make_qstorno_2100_3300 458457 458457 0 0.00 0 83338 168 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 10-03-2021 16:29:31 to 10-03-2021 16:29:35.

Memory consumption, metadata cache, attachments activity

Fields:
  page cache memo used            = page cache total size, bytes:
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = metadata cache, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000                                                                                                                                                                     

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
13:57:24 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:30 19742 8192000000 10247447904 10555478016 993351520 10.814 78 64 127 1 1018900800 3134128 22415152
13:58:01 33109 8192000000 10345114128 10659160064 1381247456 14.428 100 87 174 1 1415814960 5098192 29469312
13:58:51 27538 8192000000 10373147472 10693050368 1425400192 14.821 100 89 176 1 1460983664 6797776 28785696
13:59:37 16424 8192000000 10394996336 10722435072 1453536128 15.069 100 90 180 1 1490421072 7622944 29262000
14:00:09 16786 8192000000 10423220848 10751889408 1477803664 15.282 100 87 174 0 1513962096 7882240 28276192
14:00:39 11250 8192000000 10449311600 10778296320 1496771152 15.448 100 90 180 0 1538101328 12782528 28547648
14:01:02 13010 8192000000 10437920736 10779004928 1503712208 15.509 100 79 158 1 1537684480 8994080 24978192
14:01:36 13531 8192000000 10477518544 10824421376 1537441728 15.801 100 77 154 4 1570309616 8954960 23912928
14:01:58 16827 8192000000 10529349088 10878078976 1578564240 16.156 100 81 162 1 1612136368 9555824 24016304
14:02:24 12507 8192000000 10553572384 10902761472 1605087696 16.383 100 83 166 1 1640050592 10381616 24581280
14:02:43 10623 8192000000 10567458848 10921885696 1626005152 16.561 100 83 166 0 1662025344 11581744 24438448
14:03:10 14881 8192000000 10589746784 10948136960 1648991024 16.756 100 86 172 3 1686566272 12071312 25503936
14:03:33 16108 8192000000 10610168128 10973937664 1670700096 16.939 100 88 174 1 1709332528 13026448 25605984
14:03:59 9992 8192000000 10631813984 10994765824 1692075072 17.119 100 86 172 0 1730134208 13734576 24324560
14:04:16 8245 8192000000 10642583312 11009171456 1700841568 17.192 100 81 162 2 1738770976 14302752 23626656
14:04:31 8754 8192000000 10653680096 11022364672 1715257936 17.313 100 87 174 0 1755418048 14820144 25339968
14:04:49 9450 8192000000 10659714608 11035373568 1727665760 17.416 100 91 182 1 1768733168 15022768 26044640
14:05:06 6426 8192000000 10666855216 11043876864 1733411200 17.464 100 80 160 3 1770796192 14285632 23099360
14:05:20 7504 8192000000 10687532176 11060080640 1744556000 17.556 100 81 162 0 1781102768 13172976 23373792
14:05:37 5865 8192000000 10695285872 11069448192 1754300224 17.637 100 82 161 0 1790541872 13213600 23028048
14:05:50 3567 8192000000 10701128672 11079847936 1759283024 17.678 100 81 160 0 1795483488 13568592 22631872
14:06:01 4616 8192000000 10719296064 11093319680 1774468768 17.804 100 90 180 0 1813817184 14368848 24979568
14:06:13 3113 8192000000 10714455920 11089727488 1776632160 17.822 100 83 166 0 1813069408 12962384 23474864
14:06:23 3949 8192000000 10735877104 11111673856 1786289456 17.901 100 87 172 3 1823401696 12716656 24395584
14:06:34 2890 8192000000 10736982272 11118223360 1796344352 17.984 100 88 170 2 1832903024 12657376 23901296
14:06:43 3523 8192000000 10736176016 11124404224 1804127568 18.048 100 88 176 0 1841254960 13012016 24115376
14:06:53 3191 8192000000 10751749776 11132936192 1811127568 18.105 100 79 155 1 1844980944 12417952 21435424
14:07:02 6230 8192000000 10756363680 11139375104 1814725216 18.135 100 79 159 3 1849699632 12861072 22113344
14:07:16 6386 8192000000 10761555952 11147522048 1820248448 18.180 100 83 166 1 1856913120 13493968 23170704
14:07:30 3005 8192000000 10774143072 11163435008 1836608128 18.313 100 88 175 2 1875802128 13715408 25478592
14:07:39 2767 8192000000 10784367072 11167604736 1836761664 18.314 100 91 183 1 1876991168 14921712 25307792
14:07:49 3148 8192000000 10788150320 11169935360 1839239488 18.335 100 95 191 0 1882134128 16226384 26668256
14:07:58 2470 8192000000 10789169024 11172610048 1844846448 18.380 100 93 185 1 1886038256 15638560 25553248
14:08:07 1381 8192000000 10794101504 11179515904 1847420896 18.401 100 92 182 2 1888686992 15011344 26254752
14:08:14 1365 8192000000 10803510816 11191447552 1856408528 18.474 100 94 192 0 1899750400 17216848 26125024
14:08:23 1634 8192000000 10805319776 11190013952 1859008848 18.495 100 95 190 0 1899309248 12947136 27353264
14:08:32 2090 8192000000 10800523120 11186991104 1861566816 18.516 100 94 186 1 1901517280 14067936 25882528
14:08:40 1916 8192000000 10806862160 11194986496 1863618640 18.533 100 90 180 0 1903297488 13904832 25774016
14:08:48 1632 8192000000 10814203984 11201327104 1871302032 18.595 100 91 182 0 1910147296 13265680 25579584
14:08:56 2760 8192000000 10814217952 11204653056 1869032912 18.576 100 90 179 2 1907489952 13370656 25086384
14:09:05 1889 8192000000 10817330368 11206635520 1878312256 18.651 100 94 189 1 1916985424 12408080 26265088
14:09:13 1703 8192000000 10816419632 11206746112 1877664832 18.646 100 85 172 0 1913554976 11513904 24376240
14:09:21 49503 8192000000 10801835296 11207766016 1870870608 18.591 100 52 101 2 1892690064 6519456 15300000
14:10:18 1523 8192000000 10823622256 11214942208 1879715184 18.663 100 91 183 0 1916650336 9546144 27389008
14:10:26 10783 8192000000 10812517984 11215978496 1882568528 18.686 100 85 171 3 1917922304 11508192 23845584
14:10:44 8791 8192000000 10788079184 11212034048 1874970000 18.624 100 43 87 1 1896057840 8097392 12990448
14:10:59 4468 8192000000 10782343136 11209490432 1873604320 18.613 100 34 68 2 1890964352 7568016 9792016
14:11:10 2539 8192000000 10798282048 11214606336 1877525808 18.645 100 44 87 0 1897472144 7236624 12709712
14:11:18 3827 8192000000 10804582992 11214790656 1876906288 18.640 100 43 84 0 1896906784 8628064 11372432
14:11:30 5338 8192000000 10792687008 11215863808 1877892448 18.648 100 38 76 3 1901365856 12914592 10558816
14:11:42 5208 8192000000 10785380912 11213172736 1879031600 18.657 100 36 72 0 1896788224 7712144 10044480
14:11:56 3700 8192000000 10795180896 11219992576 1885176912 18.707 100 55 108 1 1908933520 8027344 15729264
14:12:06 6771 8192000000 10796027488 11224535040 1884490224 18.701 100 30 60 1 1900595312 8022944 8082144
14:12:24 5316 8192000000 10802244624 11220877312 1882697920 18.687 100 32 64 2 1898038880 5895792 9445168
14:12:38 13641 8192000000 10799407168 11231019008 1883319424 18.692 100 20 40 0 1899158176 10614576 5224176
14:12:58 7789 8192000000 10796775232 11227938816 1887147584 18.723 100 19 38 0 1898131872 5477456 5506832
14:13:12 10260 8192000000 10795569136 11226673152 1885883712 18.713 100 12 24 1 1894571040 5323808 3363520
14:13:32 10043 8192000000 10800697360 11230187520 1889697792 18.743 100 15 30 2 1899783872 5770576 4315504
14:13:50 59676 8192000000 10834266128 11249901568 1892334304 18.765 100 28 56 3 1905531200 4801520 8395376
14:15:10 5876 8192000000 10821592224 11250024448 1901128528 18.835 100 42 84 1 1922152432 8945856 12078048
14:15:23 4061 8192000000 10813025168 11246477312 1898655984 18.815 100 30 58 4 1918759136 11265888 8837264
14:15:36 5404 8192000000 10817759280 11248132096 1903398112 18.854 100 43 84 4 1922871632 7549968 11923552
14:15:49 6877 8192000000 10830268528 11254018048 1904584288 18.863 100 28 56 3 1918833920 6091872 8157760
14:16:03 4272 8192000000 10820608480 11254165504 1908906608 18.898 100 29 58 2 1922392032 5760656 7724768
14:16:18 6649 8192000000 10822490848 11254521856 1905694464 18.872 100 21 42 1 1917966704 5495904 6776336
14:16:32 6318 8192000000 10822757440 11247005696 1886691504 18.719 99 24 48 3 1899132512 5900192 6540816
14:16:48 6438 8192000000 10832870720 11259203584 1908300080 18.893 100 41 81 2 1928377792 7573264 12504448
14:17:01 8208 8192000000 10812627568 11249053696 1886516160 18.718 99 25 49 3 1900745952 6547040 7682752
14:17:19 5725 8192000000 10816435232 11248869376 1889578736 18.742 99 32 64 3 1905843840 7030704 9234400
14:17:32 56454 8192000000 10811614064 11245817856 1886442016 18.717 99 43 84 2 1904551584 4831296 13278272
14:18:35 10453 8192000000 10783879872 11214172160 1843199968 18.367 97 25 50 1 1856004288 6213328 6590992
14:18:51 5862 8192000000 10739931712 11155972096 1771543344 17.780 94 24 46 1 1784187008 6410128 6233536
14:19:04 5846 8192000000 10759497904 11178713088 1809629712 18.093 98 36 72 4 1827199920 7381472 10188736
14:19:17 5425 8192000000 10765306016 11183509504 1829686640 18.257 99 34 68 2 1845825104 5739856 10398608
14:19:33 3983 8192000000 10765340976 11185631232 1850005824 18.422 99 41 81 2 1866936304 5602672 11327808
14:19:47 8375 8192000000 10722643344 11147153408 1796311856 17.984 98 27 53 2 1809617936 5756096 7549984
14:20:02 8472 8192000000 10699688080 11108290560 1725141824 17.395 95 25 50 1 1737798208 5398800 7257584
14:20:16 5929 8192000000 10703692240 11120664576 1749403280 17.597 97 23 47 1 1766332112 9221216 7707616
14:20:33 4958 8192000000 10704742320 11127324672 1793324464 17.959 100 24 46 1 1807163440 6672688 7166288
14:20:44 8804 8192000000 10696209248 11111649280 1726272928 17.404 96 21 40 3 1738350288 5626064 6451296
14:21:03 8173 8192000000 10695008528 11109924864 1724659616 17.391 96 24 48 1 1737100832 5093120 7348096
14:21:21 7504 8192000000 10665298160 11074334720 1676901520 16.991 94 30 60 0 1691888768 5131168 9856080
14:21:37 15293 8192000000 10656955904 11067428864 1710520208 17.273 97 15 30 1 1720419264 5435120 4463936
14:22:03 40916 8192000000 10712737008 11103543296 1770200928 17.769 100 55 108 2 1791293392 5275776 15816688
14:22:50 7055 8192000000 10697183728 11114057728 1766946608 17.742 99 25 50 1 1781308112 7731472 6630032
14:23:05 7832 8192000000 10709054048 11127312384 1794286176 17.967 100 23 46 2 1811093072 9606400 7200496
14:23:20 9170 8192000000 10720587728 11131932672 1800001408 18.014 100 30 58 0 1815522656 6420496 9100752
14:23:37 3927 8192000000 10741087504 11148455936 1815631136 18.142 100 42 86 1 1834139440 6205536 12302768
14:23:48 7751 8192000000 10726639648 11148378112 1816453664 18.149 100 30 60 0 1831311648 5778000 9079984
14:24:02 6920 8192000000 10741390656 11159044096 1824190256 18.212 100 29 58 2 1838874928 6472352 8212320
14:24:17 9806 8192000000 10734409040 11160932352 1823624928 18.207 100 22 44 0 1835732880 6443008 5664944
14:24:35 6431 8192000000 10744536048 11159834624 1826903968 18.234 100 33 66 2 1841357520 4889056 9564496
14:24:48 13445 8192000000 10748350960 11176529920 1833642032 18.289 100 28 56 2 1847347488 5844512 7860944
14:25:08 5375 8192000000 10771061632 11187838976 1848626352 18.411 100 43 86 1 1870723568 9355264 12741952
14:25:19 13207 8192000000 10774407264 11191582720 1850906384 18.429 100 28 56 1 1864349136 4710816 8731936
14:25:41 13227 8192000000 10769363120 11194335232 1853822224 18.453 100 35 70 1 1874198208 9626912 10749072
14:26:02 66975 8192000000 10781080112 11207245824 1860047680 18.504 100 26 52 2 1872778848 4575568 8155600
14:27:18 15430 8192000000 10811628416 11226636288 1886746448 18.720 100 39 79 3 1905988896 8708016 10534432
14:27:41 71200 8192000000 10841267088 11259416576 1902438672 18.846 100 47 94 1 1926439648 11127024 12873952
14:29:09 9802 8192000000 10854877920 11272388608 1915498704 18.951 100 62 124 0 1953032048 19728048 17805296
14:29:27 18428 8192000000 10862072608 11285852160 1921065872 18.995 100 55 111 0 1955669200 19562016 15041312
14:29:56 30105 8192000000 10862692528 11291680768 1930372176 19.070 100 45 90 2 1959678624 16546048 12760400
14:30:38 17487 8192000000 10877773760 11299684352 1934241264 19.101 100 53 106 0 1967802448 18397968 15163216
14:31:02 29013 8192000000 10872065856 11305140224 1938603568 19.136 100 49 94 2 1971047568 19132160 13311840
14:31:38 20912 8192000000 10875354128 11313065984 1939469088 19.143 100 31 62 2 1965518256 17068432 8980736
14:32:08 15430 8192000000 10888844640 11320815616 1950879312 19.233 100 45 88 0 1981950976 17349504 13722160
14:32:31 23582 8192000000 10895305888 11327107072 1955086976 19.267 100 46 92 0 1989098816 20447376 13564464
14:33:02 13390 8192000000 10893475296 11325943808 1954339440 19.261 100 43 86 3 1986987872 19041616 13606816
14:33:23 15222 8192000000 10893453248 11328462848 1956110832 19.275 100 43 84 1 1987483376 18796512 12576032
14:33:47 7821 8192000000 10902128128 11331252224 1959138496 19.299 100 53 106 2 1995406528 20264896 16003136
14:34:03 1577 8192000000 10910865632 11330236416 1962088208 19.323 100 55 109 2 1996846816 18010000 16748608
14:34:12 12553 8192000000 10918442656 11344822272 1963794624 19.336 100 50 100 1 1997314032 19414240 14105168
14:34:31 15530 8192000000 10911816624 11349155840 1971486816 19.397 100 60 120 1 2012243584 22455792 18300976
14:35:01 7747 8192000000 10937595888 11358642176 1980192384 19.466 100 64 126 0 2022676240 24003344 18480512
14:35:19 6911 8192000000 10939404752 11365609472 1981092064 19.473 100 56 110 1 2025536144 28164416 16279664
14:35:39 4716 8192000000 10941470944 11372220416 1986349504 19.515 100 58 116 0 2033664128 30701680 16612944
14:35:50 2994 8192000000 10942511984 11370389504 1986933408 19.520 100 54 107 2 2028449792 25831344 15685040
14:36:03 4885 8192000000 10937063776 11372421120 1991107088 19.553 100 59 117 2 2036309184 26376944 18825152
14:36:16 2632 8192000000 10953963568 11378311168 1999916848 19.622 100 77 152 1 2046834944 24392128 22525968
14:36:25 2951 8192000000 10959082448 11379179520 1994417200 19.579 100 78 154 3 2043314128 25271520 23625408
14:36:34 3153 8192000000 10957463792 11377803264 1996069936 19.592 100 76 152 1 2044413808 26515472 21828400
14:36:44 4136 8192000000 10953906320 11383029760 1997042576 19.599 100 74 148 2 2045896224 27890208 20963440
14:36:57 4259 8192000000 10963696496 11383537664 2000247808 19.625 100 73 145 1 2048226800 27614896 20364096
14:37:09 11247 8192000000 10960160928 11391782912 1998726080 19.613 100 66 132 0 2048454400 30047648 19680672
14:37:27 21429 8192000000 10957822096 11394469888 1999606704 19.620 100 58 116 0 2047275184 30204384 17464096
14:37:57 4102 8192000000 10964474992 11396870144 2005154384 19.663 100 53 104 1 2048826736 28329328 15343024
14:38:10 4367 8192000000 10977321600 11406331904 2015944496 19.748 100 68 137 0 2065723088 29558704 20219888
14:38:21 1877 8192000000 10991440080 11416006656 2019436720 19.776 100 81 163 2 2074596688 30002608 25157360
14:38:31 4698 8192000000 10981399760 11410505728 2020600592 19.785 100 75 150 2 2075612800 31955968 23056240
14:38:46 2128 8192000000 11000301248 11421138944 2026149904 19.828 100 73 146 2 2080916592 32671408 22095280
14:38:56 7043 8192000000 11001713888 11420356608 2023675632 19.809 100 79 157 3 2081695200 33819648 24199920
14:39:10 2856 8192000000 10989323344 11404890112 1999638688 19.620 99 80 160 2 2058846448 35307504 23900256
14:39:20 1884 8192000000 10998139840 11416629248 2018218416 19.766 100 82 166 1 2078007024 35088592 24700016
14:39:29 2924 8192000000 10990663280 11422867456 2026278528 19.829 100 76 152 2 2084981216 35321728 23380960
14:39:41 6224 8192000000 10981798992 11415474176 2022132816 19.797 100 64 128 0 2071386544 29438656 19815072
14:39:55 8611 8192000000 10981472240 11418333184 2022105056 19.797 100 58 116 1 2072683424 32617008 17961360
14:40:14 9520 8192000000 10984484496 11418497024 2005850560 19.669 99 55 109 3 2059505808 36519936 17135312
14:40:33 3542 8192000000 10966769952 11390943232 1996621232 19.596 100 73 146 1 2051400864 32844512 21935120
14:40:45 9016 8192000000 10969370832 11396857856 1997518736 19.603 100 69 137 0 2052831440 34134848 21177856
14:41:04 8845 8192000000 10946579184 11375865856 1952279424 19.245 98 66 130 0 2006243232 34111344 19852464
14:41:19 5203 8192000000 10959962096 11380391936 1971024464 19.394 99 74 148 3 2029512736 35775632 22712640
14:41:33 7616 8192000000 10973285568 11397586944 1991420416 19.555 100 73 146 0 2057938368 44646720 21871232
14:41:49 3056 8192000000 10967120256 11391250432 1990305552 19.546 100 72 142 2 2053335616 40876352 22153712
14:41:59 8289 8192000000 10968827744 11391184896 1964845520 19.345 99 77 153 0 2030002224 42201808 22954896
14:42:21 3614 8192000000 10969284544 11391836160 1985280480 19.506 100 74 148 0 2052830400 44823616 22726304
14:42:32 2131 8192000000 10963665872 11378319360 1982041776 19.481 99 87 172 1 2049991216 41802768 26146672
14:42:41 4167 8192000000 10972664576 11388399616 1977070208 19.441 99 85 169 0 2042046368 38955376 26020784
14:42:54 6990 8192000000 10972274592 11396222976 1993572640 19.572 100 72 143 3 2054785824 39833632 21379552
14:43:12 5180 8192000000 10985857104 11404500992 2001827888 19.637 100 69 138 0 2064829968 41791264 21210816
14:43:25 4969 8192000000 10986162816 11416965120 2010479968 19.705 100 70 140 0 2073682128 41434224 21767936
14:43:39 4420 8192000000 10994685360 11419160576 2012585072 19.722 100 83 166 1 2082459216 42924880 26949264
14:43:51 2954 8192000000 10970470832 11396853760 1974461776 19.421 98 75 150 1 2041874016 44136416 23275824
14:44:01 3811 8192000000 10981940112 11402993664 2000776592 19.629 100 74 148 1 2067633648 43974848 22882208
14:44:13 7174 8192000000 10957427264 11400720384 1983865360 19.495 99 52 104 0 2040702624 39884880 16952384
14:44:31 14170 8192000000 10956584112 11399249920 1991462448 19.555 100 50 100 3 2050928064 42116224 17349392
14:44:52 8649 8192000000 10944603472 11386171392 1971620848 19.398 99 40 80 1 2019932080 35180784 13130448
14:45:11 12857 8192000000 10935103232 11376365568 1958806832 19.297 99 37 74 0 2011185632 40120016 12258784
14:45:31 6693 8192000000 10963713312 11392057344 1985530768 19.508 100 65 128 3 2047193712 41404768 20258176
14:45:46 2410 8192000000 10963784800 11386634240 1983473248 19.492 100 67 128 0 2042264432 38088096 20703088
14:45:56 1873 8192000000 10979552880 11396337664 1993356448 19.570 100 85 170 1 2057841200 37986512 26498240
14:46:06 4397 8192000000 10942839824 11382210560 1970465648 19.389 99 56 112 0 2025383056 36866352 18051056
14:46:22 9092 8192000000 10950090832 11388624896 1969539744 19.382 99 42 84 1 2017387632 34137184 13710704
14:46:39 9891 8192000000 10936011248 11380862976 1976400832 19.436 100 37 74 2 2025314656 36079312 12834512
14:47:05 4861 8192000000 10946452352 11384692736 1966792192 19.360 99 40 80 0 2014267248 34339984 13135072
14:47:22 3402 8192000000 10948228368 11378847744 1976527536 19.437 100 52 103 0 2030476976 36904576 17044864
14:47:34 7056 8192000000 10958023360 11396206592 1978799328 19.455 100 53 106 2 2034269872 38312272 17158272
14:47:53 5037 8192000000 10966070160 11401371648 1988280992 19.530 100 48 94 0 2045275616 41288464 15706160
14:48:07 9671 8192000000 10962027632 11407929344 1990560816 19.548 100 45 87 0 2047816256 42644400 14611040
14:48:29 4504 8192000000 10991056880 11415183360 2004646096 19.659 100 70 140 2 2066974048 39191120 23136832
14:48:44 2382 8192000000 10964936224 11390328832 1969866960 19.384 99 74 148 0 2038445472 44827184 23751328
14:48:59 12416 8192000000 10937230672 11386662912 1978634720 19.454 100 41 82 1 2039471776 46827264 14009792
14:49:24 12264 8192000000 10955379184 11400982528 1987421216 19.523 100 38 76 0 2042123968 41456560 13246192
14:49:45 18201 8192000000 10951356272 11396612096 1948462752 19.214 98 37 74 1 2009857904 48106528 13288624
14:50:20 8054 8192000000 10962916928 11400712192 1980849456 19.471 100 44 88 0 2043472128 47178400 15444272
14:50:35 14882 8192000000 10951136032 11400949760 1975957072 19.433 100 35 70 1 2035545776 47165600 12423104
14:50:57 9668 8192000000 10947983648 11398262784 1964695712 19.343 99 38 77 3 2017922864 40616720 12610432
14:51:13 19159 8192000000 10911195072 11377033216 1941824880 19.161 99 34 68 1 1992874416 39956784 11092752
14:51:54 28691 8192000000 10928390208 11383324672 1973318784 19.412 100 29 58 0 2017344400 34630544 9395072
14:52:32 21794 8192000000 10933325664 11387351040 1967408032 19.365 100 26 52 1 2018356544 41859952 9088560
14:53:01 36882 8192000000 10925782736 11392856064 1952866688 19.249 99 23 46 3 2001917088 41191904 7858496
14:53:55 20279 8192000000 10926886544 11399036928 1967141680 19.363 100 22 44 1 2012876656 37972384 7762592
14:54:32 92832 8192000000 10894284352 11342520320 1869803120 18.583 95 14 28 0 1905193952 30854864 4535968
14:56:12 50595 8192000000 10857218416 11335950336 1832313584 18.278 95 11 22 1 1874461200 38489680 3657936
14:57:09 111208 8192000000 10884753312 11322040320 1828488304 18.247 94 13 26 2 1856818416 24420816 3909296
14:59:08 38305 8192000000 10879996752 11336970240 1925023248 19.027 99 36 73 2 1941904096 7372240 9508608
14:59:57 62374 8192000000 10874735488 11335319552 1926064064 19.035 99 22 42 1 1940129680 8144176 5921440
15:01:33 64945 8192000000 10880161456 11330453504 1893712592 18.776 97 45 89 1 1919077264 12228320 13136352
15:02:49 108881 8192000000 10867516240 11324297216 1889062800 18.738 97 35 70 2 1913533680 14287120 10183760
15:04:45 40182 8192000000 10896015216 11329277952 1909022992 18.899 98 36 72 1 1929972416 10129376 10820048
15:05:33 61291 8192000000 10899085920 11345014784 1950263968 19.229 100 56 110 1 1982575168 16074000 16237200
15:06:41 49857 8192000000 10873904944 11344900096 1933661920 19.096 99 19 38 1 1950406416 10735792 6008704
15:07:51 56906 8192000000 10901357280 11369263104 1961987952 19.322 100 22 45 1 1981868864 12872096 7008816
15:08:54 65689 8192000000 10918173696 11382054912 1980397712 19.468 100 13 26 0 1997483920 13036048 4050160
15:10:06 47575 8192000000 10924994192 11398516736 1986499728 19.516 100 20 40 0 2013924480 21825216 5599536
15:11:00 30638 8192000000 10902295520 11374755840 1970649216 19.391 99 14 28 1 1994911632 19895312 4367104
15:11:37 32926 8192000000 10911008704 11393536000 1981079408 19.473 100 10 20 1 2007433280 22744560 3609312
15:12:16 87509 8192000000 10894604592 11380580352 1954170080 19.260 99 12 24 0 1973334944 15841600 3323264
15:14:35 65572 8192000000 10916031760 11390967808 1983163536 19.490 100 18 36 1 2002170928 13519600 5487792
15:16:06 74489 8192000000 10911581216 11401469952 1984945760 19.504 100 17 34 1 2004928576 15091152 4891664
15:17:27 39439 8192000000 10918564352 11387469824 1976041296 19.433 99 22 44 0 1991248208 9332016 5874896
15:18:21 58925 8192000000 10927700864 11402260480 1998251472 19.609 100 17 34 0 2013574704 10378512 4944720
15:19:30 55279 8192000000 10956605392 11428024320 2012582432 19.722 100 29 58 2 2039988064 18973776 8431856
15:20:32 42027 8192000000 10942723072 11429412864 2017783792 19.763 100 18 36 1 2038235584 15255936 5195856
15:21:29 63047 8192000000 10933067168 11420717056 1986658992 19.517 99 16 30 0 2006371376 15427008 4285376
15:22:39 46059 8192000000 10925895312 11399979008 1972699888 19.407 98 18 35 0 1989836032 11691376 5444768
15:23:41 72976 8192000000 10944696144 11414196224 2002793168 19.645 100 13 26 0 2019781808 13417200 3571440
15:25:02 29985 8192000000 10960014384 11427729408 2013835328 19.732 100 42 84 0 2047920640 20707200 13378112
15:25:46 37070 8192000000 10946758480 11417227264 1992733568 19.565 99 12 24 0 2004063408 7604672 3725168
15:26:37 45762 8192000000 10960299552 11428818944 2011452736 19.713 100 32 64 1 2030171008 10273408 8444864
15:27:32 70712 8192000000 10931586720 11399868416 1951623360 19.239 97 25 50 0 1966727312 8857792 6246160
15:28:49 85441 8192000000 10922064080 11390251008 1880726000 18.671 94 8 16 1 1895337232 12276400 2334832
15:30:21 84179 8192000000 10886506912 11349979136 1833957920 18.292 93 11 21 0 1846664800 9568352 3138528
15:31:53 99429 8192000000 10893408656 11359416320 1940833776 19.153 99 25 50 2 1955738112 7778320 7126016
15:34:09 61990 8192000000 10883693008 11330363392 1918961536 18.979 98 37 76 1 1936891104 7211136 10718432
15:35:18 28367 8192000000 10879373344 11330392064 1897633728 18.807 97 51 102 2 1922453840 9792736 15027376
15:35:53 32181 8192000000 10880097008 11348811776 1949625888 19.223 100 48 96 2 1975165408 11686256 13853264
15:36:36 69279 8192000000 10858187792 11331788800 1893691328 18.776 97 10 21 0 1904717072 8272320 2753424
15:37:51 41318 8192000000 10831546512 11306848256 1874454160 18.620 96 16 33 1 1888484624 9352880 4677584
15:38:39 27845 8192000000 10839099840 11312369664 1894764208 18.784 98 20 40 1 1908857696 7786128 6307360
15:39:19 48265 8192000000 10824125712 11296391168 1877823968 18.648 97 21 41 2 1891050496 7538480 5688048
15:40:36 68972 8192000000 10848498448 11329179648 1908033824 18.891 99 12 24 0 1922189456 10499536 3656096
15:42:22 30425 8192000000 10864087712 11333210112 1913620992 18.936 99 18 34 1 1926995232 8107856 5266384
15:42:58 68022 8192000000 10852050160 11323392000 1858265808 18.489 96 7 14 1 1870013392 9798176 1949408
15:44:13 44238 8192000000 10859036960 11320393728 1909263936 18.901 98 37 75 2 1931358944 12466400 9628608
15:45:04 31160 8192000000 10851594528 11313725440 1838183376 18.326 95 28 54 2 1856928608 10987840 7757392
15:45:46 55492 8192000000 10848055952 11313938432 1880421232 18.669 98 23 46 1 1901585840 14921968 6242640
15:47:41 46832 8192000000 10839585888 11293261824 1780652256 17.855 92 25 50 0 1795455440 8176128 6627056
15:48:40 15899 8192000000 10851151216 11302793216 1905694512 18.872 100 40 80 2 1926932176 10213664 11024000
15:49:03 13934 8192000000 10859945024 11310198784 1915287552 18.949 100 46 91 0 1941337648 13568624 12481472
15:49:27 53331 8192000000 10871298096 11322277888 1919775040 18.985 100 37 74 1 1945038096 15106672 10156384
15:50:27 46673 8192000000 10846936272 11328544768 1915363344 18.950 99 23 46 0 1937877296 15834944 6679008
15:51:20 102804 8192000000 10863242448 11324936192 1840524400 18.345 95 15 30 1 1861234176 16310288 4399488
15:53:11 58889 8192000000 10871298352 11341160448 1923174672 19.012 100 8 16 1 1949547008 24107200 2265136
15:54:34 146615 8192000000 10871517616 11349770240 1941611872 19.160 100 14 27 1 1962478464 17243440 3623152
15:57:06 22461 8192000000 10885569664 11351982080 1960821616 19.313 100 29 60 1 1981574688 12771168 7981904
15:57:38 61646 8192000000 10859246272 11341496320 1900359760 18.829 97 11 22 0 1914312496 11189984 2762752
15:58:46 35497 8192000000 10859129040 11338448896 1944932576 19.186 100 5 10 0 1952766224 6856560 977088
15:59:37 39063 8192000000 10861199296 11331067904 1893572256 18.775 97 10 20 1 1904814832 8628320 2614256
16:00:25 34153 8192000000 10868175760 11346415616 1924410304 19.022 99 10 20 0 1934246816 7638928 2197584
16:01:06 46296 8192000000 10896390272 11364868096 1945914192 19.194 99 21 40 2 1961353648 10472208 4967248
16:02:02 24812 8192000000 10905885200 11376070656 1972058176 19.402 100 24 48 1 1989204512 10756208 6390128
16:02:33 33552 8192000000 10923877920 11390808064 1984559216 19.501 100 23 46 0 2003922176 12683024 6679936
16:03:19 56910 8192000000 10925264336 11398983680 1975435648 19.429 99 27 54 0 1996528752 13442768 7650336
16:04:25 43795 8192000000 10943992288 11409580032 1999735904 19.621 100 26 50 1 2020829952 13101472 7992576
16:05:15 94173 8192000000 10946905712 11418664960 2004205120 19.656 100 22 44 1 2022544368 12038384 6300864
16:07:02 70294 8192000000 10923383520 11396718592 1945585536 19.191 97 20 40 0 1965603360 14805696 5212128
16:08:19 16720 8192000000 10934282992 11399258112 1994469408 19.579 100 46 91 1 2015202960 7094912 13638640
16:08:53 39600 8192000000 10959346816 11418763264 2009150736 19.695 100 36 72 2 2032585376 13461280 9973360
16:09:41 19343 8192000000 10923249664 11387621376 1971297872 19.396 99 48 96 1 1997910832 13069104 13543856
16:10:13 55174 8192000000 10943063136 11400712192 1970733440 19.391 99 29 58 2 1991199280 12318272 8147568
16:11:19 85209 8192000000 10954397696 11412676608 1998138544 19.608 100 15 30 0 2012765808 10718016 3909248
16:12:52 32444 8192000000 10961653936 11429789696 2015526240 19.745 100 36 71 1 2040299664 14813200 9960224
16:13:32 111937 8192000000 10927942304 11419557888 1918393392 18.974 96 13 26 0 1940877584 19324288 3159904
16:15:35 158424 8192000000 10894624784 11362349056 1838328640 18.327 92 22 44 2 1854685360 10036784 6319936
16:18:20 88993 8192000000 10891702528 11380891648 1946830720 19.201 99 13 26 1 1963749616 13553280 3365616
16:19:55 13749 8192000000 10882554352 11375058944 1958603936 19.295 100 2 4 0 1975387888 15936448 847504
16:20:15 12383 8192000000 10892535296 11375611904 1964458064 19.341 100 12 20 0 1982511376 14831920 3221392
16:20:34 44778 8192000000 10876375008 11357073408 1915023792 18.947 97 22 44 2 1929956640 9076688 5856160
16:21:25 81178 8192000000 10865214816 11343900672 1900563776 18.831 97 9 18 0 1911193680 8082704 2547200
16:23:44 64661 8192000000 10888487728 11375509504 1952492096 19.246 100 19 38 1 1982517232 24534096 5491040
16:26:13 74113 8192000000 9628564976 9973596160 766488352 8.556 39 12 24 0 784862784 14829536 3544896

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 10-03-2021 16:29:37 to 10-03-2021 16:30:08.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 194 v_add_invoice_to_stock 335544517
except 12 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 10-03-2021 16:30:09 to 10-03-2021 16:30:11.

Content of mon$database and FB version

MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          234881
MON$OLDEST_ACTIVE               234882
MON$OLDEST_SNAPSHOT             234882
MON$NEXT_TRANSACTION            234882
MON$PAGE_BUFFERS                1000000
MON$SQL_DIALECT                 3
MON$SHUTDOWN_MODE               0
MON$SWEEP_INTERVAL              0
MON$READ_ONLY                   0
MON$FORCED_WRITES               1
MON$RESERVE_SPACE               1
MON$CREATION_DATE               2020-04-03 16:41:55.3470
MON$PAGES                       2027872
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.8.33423 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33423 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33423 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33423 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================

Database validation

Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test

--- start of diff output ---
:265: 
:266: mscs-test-161.budzdorov.ru    Wed Mar 10 16:28:08 2021
:267:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:268: 
--- end of diff output ---

Final processing ISQL logs in /var/tmp/logs-oltp30 according to config parameter 'remove_isql_logs'

10.03.21 16:30:12. There are 3 logs in /var/tmp/logs-oltp30 that can be removed if no severe errors occured, see config setting 'remove_isql_logs' Following values of gdscode are considered as SEVERE: 0 Unidentified error in PSQL code: gdscode=0 within WHEN block when exception raised. 335544321 'string truncation'. Attempt to assign too long text into string variable. 335544347 'not_valid'. Validation error for column. 335544349 'no_dup'. Attempt to store duplicate value visible to active transactions. 335544558 'check_constraint'. Operation violates CHECK constraint on view or table. 335544665 'unique_key_violation'. Violation of PRIMARY or UNIQUE KEY constraint. 335544838 'foreign_key_target_doesnt_exist'. Foreign key reference target does not exist. 335544839 'foreign_key_references_present'. Foreign key references are present for the record.
FINISHED_AT ERRORS_RESULT
2021-03-10 16:30:14 No severe PSQL-related problems occured
10.03.21 16:30:16. End of report.