Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 21.02.2021 22:28
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 e0e7b46250ba4f9795ceb55e0face73f
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 2020-09-25 13:42
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.00
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 16898580 kB
MemAvailable 31126872 kB
Buffers 0 kB
Cached 14794444 kB
SwapCached 3892 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-02-21 22:27:19
DTS_END                         2021-02-21 22:27:19.4010
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/47460
TRN_ID                          239070
ATT_ID                          663
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: 9027.27 23216 1083272
customer order: creation 171.81 380 20617
customer order: refuse 14.76 355 1771
order to supplier: creation 45.89 1396 5507
order to supplier: removal 3.62 101423 434
invoice (draft): creation 46.73 3530 5608
invoice (draft): removal 50.94 956 6113
invoice accept: apply 41.93 18563 5031
invoice accept: cancel 45.48 853 5458
customer reserve: creation 3809.87 186 457184
customer reserve: removal 4503.33 62 540400
realization accept: apply 83.12 170 9974
realization accept: cancel 78.83 120 9460
payment from customer: creation 60.48 125 7258
payment from customer: removal 5.41 83 649
payment to supplier: creation 49.53 125 5944
payment to supplier: removal 3.41 85 409
service: total inventory turnovers 4.76 1192 571
service: total monetary turnovers 6.59 84 791
service: aggregate perf. data 0.74 26818 89
service: refresh index statistics 0.03 307816 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 21-02-2021 22:28:46 to 21-02-2021 22:28:48.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4633
TEST_TIME 2 5563
TEST_TIME 3 6537
TEST_TIME 4 6985
TEST_TIME 5 6753
TEST_TIME 6 6553
TEST_TIME 7 6312
TEST_TIME 8 6367
TEST_TIME 9 6442
TEST_TIME 10 6332
TEST_TIME 11 6272
TEST_TIME 12 6253
TEST_TIME 13 6567
TEST_TIME 14 6752
TEST_TIME 15 7077
TEST_TIME 16 7315
TEST_TIME 17 7508
TEST_TIME 18 7516
TEST_TIME 19 7601
TEST_TIME 20 7810
TEST_TIME 21 8132
TEST_TIME 22 8136
TEST_TIME 23 8289
TEST_TIME 24 8387
TEST_TIME 25 8688
TEST_TIME 26 8573
TEST_TIME 27 8882
TEST_TIME 28 9645
TEST_TIME 29 11183
TEST_TIME 30 11222
TEST_TIME 31 11143
TEST_TIME 32 10854
TEST_TIME 33 10703
TEST_TIME 34 10685
TEST_TIME 35 10621
TEST_TIME 36 10587
TEST_TIME 37 10400
TEST_TIME 38 10266
TEST_TIME 39 10247
TEST_TIME 40 10281
TEST_TIME 41 10117
TEST_TIME 42 10214
TEST_TIME 43 10152
TEST_TIME 44 10050
TEST_TIME 45 10055
TEST_TIME 46 10049
TEST_TIME 47 10075
TEST_TIME 48 10087
TEST_TIME 49 10118
TEST_TIME 50 9971
TEST_TIME 51 9806
TEST_TIME 52 9816
TEST_TIME 53 9794
TEST_TIME 54 9766
TEST_TIME 55 9751
TEST_TIME 56 9717
TEST_TIME 57 9680
TEST_TIME 58 9765
TEST_TIME 59 9743
TEST_TIME 60 9688
TEST_TIME 61 9617
TEST_TIME 62 9602
TEST_TIME 63 9493
TEST_TIME 64 9449
TEST_TIME 65 9394
TEST_TIME 66 9374
TEST_TIME 67 9432
TEST_TIME 68 9388
TEST_TIME 69 9478
TEST_TIME 70 9509
TEST_TIME 71 9482
TEST_TIME 72 9510
TEST_TIME 73 9490
TEST_TIME 74 9470
TEST_TIME 75 9519
TEST_TIME 76 9574
TEST_TIME 77 9549
TEST_TIME 78 9566
TEST_TIME 79 9659
TEST_TIME 80 9639
TEST_TIME 81 9542
TEST_TIME 82 9483
TEST_TIME 83 9430
TEST_TIME 84 9426
TEST_TIME 85 9421
TEST_TIME 86 9365
TEST_TIME 87 9394
TEST_TIME 88 9350
TEST_TIME 89 9324
TEST_TIME 90 9274
TEST_TIME 91 9220
TEST_TIME 92 9194
TEST_TIME 93 9172
TEST_TIME 94 9254
TEST_TIME 95 9279
TEST_TIME 96 9304
TEST_TIME 97 9308
TEST_TIME 98 9289
TEST_TIME 99 9312
TEST_TIME 100 9375
TEST_TIME 101 9348
TEST_TIME 102 9389
TEST_TIME 103 9377
TEST_TIME 104 9381
TEST_TIME 105 9344
TEST_TIME 106 9349
TEST_TIME 107 9295
TEST_TIME 108 9262
TEST_TIME 109 9240
TEST_TIME 110 9204
TEST_TIME 111 9153
TEST_TIME 112 9130
TEST_TIME 113 9106
TEST_TIME 114 9120
TEST_TIME 115 9127
TEST_TIME 116 9114
TEST_TIME 117 9087
TEST_TIME 118 9078
TEST_TIME 119 9083
TEST_TIME 120 9030

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 21-02-2021 22:28:50 to 21-02-2021 22:28:53.

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 1505695 1505695 0 0.00 0 17621 6 0 0
doc_list_biud 1505694 1505694 0 0.00 0 50149 29 0 0
sp_add_invoice_to_stock 5127 5031 96 1.87 37 168385 18563 0 96
sp_cancel_adding_invoice 5458 5458 0 0.00 4 63642 854 0 0
sp_cancel_client_order 1771 1771 0 0.00 5 7690 356 0 0
sp_cancel_customer_reserve 540400 540400 0 0.00 1 30481 62 0 0
sp_cancel_pay_from_customer 649 649 0 0.00 2 5041 84 0 0
sp_cancel_pay_to_supplier 409 409 0 0.00 3 4086 85 0 0
sp_cancel_supplier_invoice 6121 6113 8 0.13 1 50155 956 0 8
sp_cancel_supplier_order 434 434 0 0.00 9 1019626 101424 0 0
sp_cancel_write_off 9460 9460 0 0.00 1 20116 120 0 0
sp_client_order 20617 20617 0 0.00 4 27899 381 0 0
sp_customer_reserve 457184 457184 0 0.00 0 90766 187 0 0
sp_fill_shopping_cart 31719 31719 0 0.00 1 16377 39 0 0
sp_fill_shopping_cart_clo_res 457177 457177 0 0.00 0 17413 13 0 0
sp_get_clo_for_invoice 5024 5024 0 0.00 0 26299 279 0 0
sp_kill_cost_storno 15976 15976 0 0.00 0 17612 66 0 0
sp_kill_qstorno_ret_qs2qd 1096807 1096807 0 0.00 0 50146 34 0 0
sp_kill_qty_storno 578633 578633 0 0.00 0 50147 74 0 0
sp_lock_selected_doc 20817 20817 0 0.00 0 9388 7 0 0
sp_make_cost_storno 28200 28200 0 0.00 0 12247 49 0 0
sp_multiply_rows_for_pdistr 28200 28200 0 0.00 0 7153 31 0 0
sp_multiply_rows_for_qdistr 20617 20617 0 0.00 0 11704 149 0 0
sp_pay_from_customer 7258 7258 0 0.00 4 14807 125 0 0
sp_pay_to_supplier 5944 5944 0 0.00 5 11471 126 0 0
sp_payment_common 13202 13202 0 0.00 1 12659 28 0 0
sp_qd_handle_on_cancel_clo 1771 1771 0 0.00 0 7288 320 0 0
sp_qd_handle_on_invoice_upd_sts 10482 10482 0 0.00 0 24534 360 0 0
sp_qd_handle_on_reserve_upd_sts 9973 9973 0 0.00 0 20293 50 0 0
sp_reserve_write_off 9974 9974 0 0.00 6 20322 171 0 0
sp_supplier_invoice 5608 5608 0 0.00 6 112345 3531 0 0
sp_supplier_order 5507 5507 0 0.00 5 56261 1396 0 0
srv_aggregate_perf_data 89 89 0 0.00 3083 630975 26819 0 0
srv_fill_mon_cache_memory 173 173 0 0.00 796 134789 29898 0 0
srv_find_qd_qs_mism 1035041 1035041 0 0.00 0 12862 6 0 0
srv_make_invnt_saldo 571 571 0 0.00 53 148725 1192 0 0
srv_make_money_saldo 791 791 0 0.00 1 24300 84 0 0
srv_recalc_idx_stat 4 4 0 0.00 120150 410497 307817 0 0
t$perf-abend:sp_add_invoice_to_stock 96 96 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5031 5031 0 0.00 0 20004 213 0 0
t$perf-norm:sp_cancel_adding_invoice 365 365 0 0.00 0 3014 89 0 0
t$perf-norm:sp_cancel_client_order 1771 1771 0 0.00 0 1846 12 0 0
t$perf-norm:sp_cancel_customer_reserve 697 697 0 0.00 0 1524 14 0 0
t$perf-norm:sp_cancel_pay_from_customer 649 649 0 0.00 0 2678 11 0 0
t$perf-norm:sp_cancel_pay_to_supplier 409 409 0 0.00 0 415 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 415 415 0 0.00 0 16967 56 0 0
t$perf-norm:sp_cancel_supplier_order 434 434 0 0.00 0 26539 1558 0 0
t$perf-norm:sp_cancel_write_off 1087 1087 0 0.00 0 2956 11 0 0
t$perf-norm:sp_client_order 20618 20618 0 0.00 0 19370 21 0 0
t$perf-norm:sp_customer_reserve 1046 1046 0 0.00 0 928 4 0 0
t$perf-norm:sp_pay_from_customer 7258 7258 0 0.00 0 9381 15 0 0
t$perf-norm:sp_pay_to_supplier 5944 5944 0 0.00 0 2780 7 0 0
t$perf-norm:sp_reserve_write_off 9974 9974 0 0.00 0 18886 20 0 0
t$perf-norm:sp_supplier_invoice 5608 5608 0 0.00 0 17034 26 0 0
t$perf-norm:sp_supplier_order 5507 5507 0 0.00 0 8341 17 0 0
t$perf-norm:srv_aggregate_perf_data 89 89 0 0.00 0 234 8 0 0
t$perf-norm:srv_fill_mon_cache_memory 173 173 0 0.00 0 811 10 0 0
t$perf-norm:srv_make_invnt_saldo 571 571 0 0.00 0 2130 28 0 0
t$perf-norm:srv_make_money_saldo 791 791 0 0.00 0 13866 39 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 5 3 0 0
v_add_invoice_to_stock 10224 10032 192 1.87 0 6545 22 0 192
v_all_customers 37568 37568 0 0.00 0 30 1 0 0
v_all_suppliers 30864 30864 0 0.00 0 126 1 0 0
v_all_wares 41232 41232 0 0.00 0 177 1 0 0
v_cancel_adding_invoice 730 730 0 0.00 0 1203 8 0 0
v_cancel_client_order 3542 3542 0 0.00 0 7562 9 0 0
v_cancel_customer_prepayment 1298 1298 0 0.00 0 5014 9 0 0
v_cancel_customer_reserve 1394 1394 0 0.00 0 5163 8 0 0
v_cancel_payment_to_supplier 818 818 0 0.00 0 1411 6 0 0
v_cancel_supplier_invoice 846 830 16 1.89 0 7315 31 0 16
v_cancel_supplier_order 868 868 0 0.00 0 1914 6 0 0
v_cancel_write_off 2174 2174 0 0.00 0 6300 16 0 0
v_max_id_clo_ord 5504 5504 0 0.00 0 609 1 0 0
v_max_id_clo_res 1046 1046 0 0.00 0 2806 12 0 0
v_max_id_ord_sup 5599 5599 0 0.00 0 4779 5 0 0
v_max_non_paid_invoice 1615 1615 0 0.00 0 513 3 0 0
v_max_non_paid_realizn 3880 3880 0 0.00 0 1459 3 0 0
v_min_id_clo_ord 5504 5504 0 0.00 0 2406 7 0 0
v_min_id_clo_res 1046 1046 0 0.00 0 1573 4 0 0
v_min_id_ord_sup 5599 5599 0 0.00 0 4635 7 0 0
v_min_non_paid_invoice 5944 5944 0 0.00 0 6245 16 0 0
v_min_non_paid_realizn 7258 7258 0 0.00 0 12653 19 0 0
v_our_firm 10420 10420 0 0.00 0 13 1 0 0
v_reserve_write_off 19946 19946 0 0.00 0 9104 8 0 0
x_lock_depdocs_on_canc_invoice 11156 11156 0 0.00 0 18866 136 0 0
x_lock_depdocs_on_canc_sup_ord 434 434 0 0.00 0 5258 378 0 0
x_make_qstorno_1000_1200 5507 5507 0 0.00 2 56248 1311 0 0
x_make_qstorno_1200_2000 5608 5608 0 0.00 3 112338 3395 0 0
x_make_qstorno_2100_3300 457184 457184 0 0.00 0 90764 171 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 21-02-2021 22:28:54 to 21-02-2021 22:28:58.

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
19:57:22 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:28 18445 8192000000 10241485104 10548264960 828001216 9.179 64 48 102 0 845295840 2197168 15097456
19:57:56 33782 8192000000 10360226496 10674696192 1393358416 14.536 100 92 181 1 1427495616 4895600 29241600
19:58:44 30251 8192000000 10386708928 10708836352 1426596944 14.831 100 90 180 0 1462606096 6564208 29444944
19:59:36 26615 8192000000 10414125152 10739732480 1463182720 15.154 100 90 179 0 1499595648 7829008 28583920
20:00:14 20873 8192000000 10434242304 10765037568 1485408896 15.349 100 88 176 1 1521363936 8172112 27782928
20:00:49 22068 8192000000 10460706976 10796113920 1511500704 15.576 100 88 176 0 1548242672 8926928 27815040
20:01:21 10264 8192000000 10468536096 10807885824 1527066768 15.712 100 82 164 1 1562257040 9504320 25685952
20:01:45 20489 8192000000 10494724304 10847023104 1547401744 15.888 100 73 146 0 1579239056 9361456 22475856
20:02:14 15284 8192000000 10530819856 10885672960 1594280352 16.290 100 75 149 3 1626707296 9919168 22507776
20:02:38 11803 8192000000 10551509024 10910060544 1619777552 16.508 100 73 146 1 1652047856 10461936 21808368
20:02:58 10495 8192000000 10581978128 10944020480 1650237792 16.766 100 82 164 1 1685910320 11589312 24083216
20:03:17 12793 8192000000 10602777184 10967138304 1658230720 16.834 100 81 162 0 1694117632 11923904 23963008
20:03:40 7752 8192000000 10617133968 10982076416 1673495920 16.963 100 79 156 1 1707958432 11708720 22753792
20:04:00 8028 8192000000 10632050384 11003498496 1693642768 17.132 100 77 154 2 1728210672 12450496 22117408
20:04:16 7073 8192000000 10656251648 11028213760 1719513888 17.348 100 85 169 3 1756662480 13268304 23880288
20:04:32 7485 8192000000 10672615840 11047632896 1726736352 17.408 100 73 146 2 1759690944 12340912 20613680
20:04:47 8780 8192000000 10677185072 11052867584 1741512864 17.531 100 73 144 1 1775343600 12731152 21099584
20:05:03 4658 8192000000 10694509904 11073495040 1754402512 17.638 100 78 156 0 1789208720 12469952 22336256
20:05:17 4790 8192000000 10700126736 11081158656 1767050592 17.743 100 79 158 1 1800925248 11900064 21974592
20:05:30 4508 8192000000 10708188768 11091513344 1772148704 17.785 100 80 160 0 1807117376 12548576 22420096
20:05:41 4877 8192000000 10721994560 11101929472 1780093280 17.850 100 79 155 1 1813852576 12972576 20786720
20:05:53 5024 8192000000 10730713456 11111079936 1785426400 17.894 100 84 168 0 1822492416 14369936 22696080
20:06:05 2954 8192000000 10737564352 11119681536 1791783632 17.946 100 82 164 1 1829349136 15286608 22278896
20:06:14 3135 8192000000 10737195616 11119595520 1799713024 18.012 100 91 182 0 1840878144 15941728 25223392
20:06:31 6035 8192000000 10749191840 11133222912 1799226816 18.008 100 85 170 1 1836689664 14091968 23370880
20:06:44 4234 8192000000 10754312416 11144855552 1819555888 18.174 100 88 176 2 1858662160 14202640 24903632
20:06:56 3358 8192000000 10765164624 11149316096 1822328784 18.197 100 82 165 1 1859642112 14318928 22994400
20:07:06 2704 8192000000 10758204064 11149623296 1827230320 18.237 100 84 168 1 1865599088 14482608 23886160
20:07:15 2118 8192000000 10777396128 11162013696 1833049632 18.284 100 89 178 0 1870820064 12745232 25025200
20:07:24 2446 8192000000 10787421600 11170410496 1837724800 18.322 100 92 183 0 1876599584 12847072 26027712
20:07:33 2354 8192000000 10781492112 11170525184 1844232320 18.375 100 86 172 1 1880948256 12117568 24598368
20:07:42 2875 8192000000 10792244544 11180482560 1854258112 18.457 100 85 168 2 1888491072 11244368 22988592
20:07:51 4712 8192000000 10800378672 11189923840 1856528176 18.475 100 93 185 2 1896143424 12886192 26729056
20:08:03 2201 8192000000 10802734528 11193188352 1860283184 18.506 100 95 188 0 1899988128 12975520 26729424
20:08:12 1820 8192000000 10811476704 11198586880 1864554240 18.540 100 90 182 1 1903616768 13374928 25687600
20:08:20 2210 8192000000 10807579008 11198644224 1865583488 18.549 100 85 170 1 1902866912 12626464 24656960
20:08:29 2281 8192000000 10807260912 11198115840 1869263936 18.578 100 94 189 0 1909347968 13510528 26573504
20:08:37 44649 8192000000 10787740528 11197149184 1864798016 18.542 100 65 128 3 1893153984 9963808 18392160
20:09:29 1476 8192000000 10817102720 11207622656 1873260704 18.611 100 91 184 1 1909210320 10051984 25897632
20:09:37 4842 8192000000 10799022368 11208531968 1868428768 18.572 100 55 111 0 1895804016 12017936 15357312
20:09:49 2942 8192000000 10788396096 11200163840 1867260112 18.562 100 50 100 1 1890479040 9375328 13843600
20:10:03 3888 8192000000 10791221040 11207696384 1869559744 18.581 100 45 90 0 1890850144 8961856 12328544
20:10:15 2781 8192000000 10791918400 11208429568 1871107136 18.593 100 49 98 0 1895574864 9998832 14468896
20:10:24 4827 8192000000 10792856784 11206803456 1873155184 18.610 100 54 108 0 1897733680 9255504 15322992
20:10:36 5634 8192000000 10784655264 11211059200 1871247312 18.594 100 30 60 3 1890896112 11623056 8025744
20:10:50 6546 8192000000 10780368768 11208261632 1874083504 18.617 100 38 74 1 1893056112 8100320 10872288
20:11:04 5846 8192000000 10782244944 11208359936 1874178784 18.618 100 25 50 1 1887258224 5494800 7584640
20:11:19 7183 8192000000 10808640064 11223515136 1879577616 18.662 100 29 58 1 1898523008 10979008 7966384
20:11:37 14011 8192000000 10784616896 11218853888 1881504640 18.677 100 27 53 1 1895379488 5804176 8070672
20:11:57 56242 8192000000 10795531328 11227414528 1884449904 18.701 100 39 78 0 1901982832 5721376 11811552
20:13:02 6080 8192000000 10801262688 11227545600 1886196496 18.715 100 27 54 0 1899362544 5797424 7368624
20:13:16 8644 8192000000 10813736096 11233501184 1884833840 18.704 100 27 55 0 1898809072 6362384 7612848
20:13:31 5209 8192000000 10806461120 11231891456 1889945904 18.745 100 32 64 3 1906144288 5511120 10687264
20:13:44 6258 8192000000 10813013904 11242737664 1890522672 18.750 100 33 66 0 1907298080 7811168 8964240
20:14:02 4627 8192000000 10812854128 11240964096 1892525712 18.766 100 32 64 1 1913339408 11618320 9195376
20:14:16 6712 8192000000 10805272464 11239227392 1889423280 18.741 100 27 54 1 1908297536 11485760 7388496
20:14:31 8965 8192000000 10799800944 11231866880 1889206544 18.739 100 27 55 1 1902839792 4701392 8931856
20:14:47 6171 8192000000 10811467840 11240603648 1891906912 18.761 100 26 50 1 1905197888 6180640 7110336
20:14:59 8066 8192000000 10803849392 11233071104 1874677136 18.622 99 24 48 2 1887045888 5852032 6516720
20:15:14 7561 8192000000 10818036112 11241459712 1894004544 18.778 100 21 42 2 1905144320 5221920 5917856
20:15:30 5866 8192000000 10817357536 11246301184 1895682544 18.792 100 16 32 0 1905748448 5375760 4690144
20:15:42 8662 8192000000 10813720624 11245723648 1898287824 18.813 100 25 50 3 1916009936 10561568 7160544
20:15:57 8548 8192000000 10810305008 11242049536 1882757648 18.687 99 19 39 1 1893541376 5558032 5225696
20:16:11 64224 8192000000 10830966656 11259260928 1902412672 18.846 100 40 81 2 1920025936 5024656 12588608
20:17:26 7291 8192000000 10815169184 11247394816 1898217456 18.812 100 15 30 1 1907390592 4726272 4446864
20:17:40 8594 8192000000 10797765968 11225759744 1835750416 18.306 97 15 29 1 1845676432 5699104 4226912
20:17:56 3215 8192000000 10782337872 11205984256 1835216000 18.302 97 33 66 2 1849618896 5198128 9204768
20:18:09 5390 8192000000 10748079360 11171627008 1799557376 18.010 97 26 51 0 1814270272 7410064 7302832
20:18:24 4284 8192000000 10748919056 11173896192 1822199552 18.196 98 43 83 6 1840033024 5608288 12225184
20:18:36 11217 8192000000 10775660608 11202260992 1843116336 18.366 99 28 55 0 1857372464 6504368 7751760
20:18:53 6572 8192000000 10745562944 11167154176 1778889232 17.840 96 24 48 3 1791313632 5100544 7323856
20:19:06 7007 8192000000 10730011376 11153403904 1777369840 17.828 97 29 58 1 1793672656 7330592 8972224
20:19:22 6735 8192000000 10731065248 11153711104 1804425424 18.050 99 38 75 3 1822279296 6315424 11538448
20:19:40 10359 8192000000 10708133264 11127156736 1730485808 17.440 95 20 40 0 1741567776 4931360 6150608
20:19:57 5369 8192000000 10731230112 11141943296 1792239392 17.950 99 34 68 2 1809004000 6966256 9798352
20:20:17 6277 8192000000 10694726160 11098767360 1719747680 17.350 96 35 69 1 1737037168 5434768 11854720
20:20:30 6365 8192000000 10700856016 11119128576 1778467856 17.837 99 29 59 1 1796524928 9528224 8528848
20:20:43 85011 8192000000 10743250448 11152560128 1698574240 17.173 93 44 88 2 1717777120 5923776 13279104
20:22:16 3506 8192000000 10732843888 11144069120 1785267664 17.893 98 51 100 2 1808601200 8962256 14371280
20:22:26 6304 8192000000 10735703472 11155251200 1817880864 18.160 100 35 69 1 1834882704 7247968 9753872
20:22:40 7559 8192000000 10719816848 11140669440 1804019456 18.047 99 31 61 4 1818774624 5569136 9186032
20:22:56 7434 8192000000 10723433360 11135455232 1780135552 17.851 98 34 67 4 1796454848 5944448 10374848
20:23:12 8062 8192000000 10748603104 11154718720 1801723088 18.028 99 30 60 0 1816293328 5877792 8692448
20:23:27 6163 8192000000 10753508784 11169550336 1822629168 18.199 100 26 53 0 1835352832 5301968 7421696
20:23:45 11942 8192000000 10740064080 11167186944 1827129792 18.236 100 25 50 0 1840141792 6035280 6976720
20:24:06 4780 8192000000 10772118992 11181408256 1840041520 18.341 100 38 77 1 1857130800 5111232 11978048
20:24:19 9966 8192000000 10766843520 11189223424 1843928704 18.373 100 31 61 1 1859229136 5794640 9505792
20:24:38 6066 8192000000 10771245008 11195170816 1852572960 18.443 100 29 58 1 1870682336 9842784 8266592
20:24:52 10812 8192000000 10764242672 11194179584 1852904592 18.446 100 21 42 0 1864559152 5285392 6369168
20:25:11 6074 8192000000 10774034112 11199016960 1854216320 18.456 100 17 34 0 1864547376 5643184 4687872
20:25:23 66999 8192000000 10813393728 11215757312 1867618640 18.565 100 57 114 0 1890081168 6113104 16349424
20:26:36 9233 8192000000 10764793936 11205435392 1862071760 18.520 100 17 34 0 1873073376 6202864 4798752
20:26:55 6492 8192000000 10784485216 11212107776 1869257088 18.578 100 28 56 1 1883388576 6253344 7878144
20:27:11 10173 8192000000 10816495632 11231956992 1887835680 18.728 100 33 67 2 1902512400 5070976 9605744
20:27:29 35256 8192000000 10834835680 11255529472 1903659824 18.856 100 44 85 2 1923482880 7180080 12642976
20:28:12 8819 8192000000 10855367680 11272540160 1919232576 18.981 100 58 116 2 1944557440 9176304 16148560
20:28:29 11296 8192000000 10848223792 11271462912 1925002896 19.027 100 53 105 1 1949978976 10090992 14885088
20:28:51 11139 8192000000 10869682400 11283124224 1930593440 19.072 100 64 128 1 1960560672 11458528 18508704
20:29:10 22010 8192000000 10863133840 11287228416 1931163920 19.076 100 45 90 0 1954481648 10871200 12446528
20:29:41 13678 8192000000 10883270288 11295727616 1938859328 19.138 100 55 110 1 1965723152 10599040 16264784
20:30:02 3856 8192000000 10876946416 11298918400 1941649040 19.160 100 59 116 1 1973956832 15787984 16519808
20:30:12 10940 8192000000 10878806672 11303739392 1945152928 19.188 100 55 109 1 1971954400 11509296 15292176
20:30:32 13697 8192000000 10888955056 11310100480 1949453184 19.222 100 58 116 0 1979001968 11542592 18006192
20:30:57 58741 8192000000 10876052064 11311833088 1945132384 19.188 100 33 66 1 1966888928 11734032 10022512
20:32:09 7260 8192000000 10882479232 11311980544 1950905472 19.234 100 40 78 3 1972955184 10547808 11501904
20:32:26 12357 8192000000 10884309648 11315728384 1953968976 19.258 100 46 91 1 1979760992 12777696 13014320
20:32:46 22077 8192000000 10879058816 11323936768 1953085232 19.251 100 35 70 2 1977817280 14399840 10332208
20:33:16 3026 8192000000 10878212688 11319451648 1952734576 19.248 100 26 52 0 1969920688 9682784 7503328
20:33:30 30291 8192000000 10889157888 11326664704 1957476208 19.286 100 32 64 1 1979388192 12714032 9197952
20:34:12 2965 8192000000 10913545360 11341295616 1973387808 19.412 100 54 108 0 2002065696 13362400 15315488
20:34:22 4462 8192000000 10919464624 11348680704 1981198192 19.474 100 55 108 1 2011453264 14765216 15489856
20:34:34 14684 8192000000 10935538752 11360071680 1984291920 19.499 100 55 108 0 2018100048 17359456 16448672
20:34:57 11318 8192000000 10925550624 11361710080 1986018912 19.512 100 56 112 1 2021160816 18108960 17032944
20:35:27 21797 8192000000 10941052528 11374657536 1987831616 19.527 100 46 92 2 2018396656 17252560 13312480
20:35:58 6282 8192000000 10929587808 11359830016 1975511456 19.429 99 54 109 2 2009315248 17657888 16145904
20:36:14 6772 8192000000 10932453488 11368402944 1988541824 19.532 100 52 103 1 2022112304 18251456 15319024
20:36:29 16685 8192000000 10943222064 11375083520 1991965888 19.559 100 49 98 1 2025060064 19018624 14075552
20:36:55 10331 8192000000 10932704672 11375398912 1995166272 19.585 100 51 102 0 2030758752 19895920 15696560
20:37:13 10382 8192000000 10933906512 11378167808 1996226896 19.593 100 40 80 0 2026675952 18825600 11623456
20:37:34 4638 8192000000 10934933872 11372683264 1990331600 19.546 100 57 111 0 2025002240 18600304 16070336
20:37:59 9007 8192000000 10938895280 11376971776 1999740688 19.621 100 62 123 2 2036565488 19437024 17387776
20:38:18 6077 8192000000 10956248208 11380146176 1998221536 19.609 100 71 142 1 2040514384 20735568 21557280
20:38:37 4169 8192000000 10956262960 11386867712 2002801808 19.645 100 62 124 0 2042874640 21784304 18288528
20:38:50 5690 8192000000 10940917648 11369918464 1985805088 19.511 99 62 123 0 2024863280 20810384 18247808
20:39:05 2358 8192000000 10958200960 11386810368 2002957792 19.646 100 69 138 0 2045810784 21155248 21697744
20:39:16 7889 8192000000 10947018848 11384086528 1995067856 19.584 100 52 104 0 2032492064 21869280 15554928
20:39:32 2897 8192000000 10951912624 11371839488 1984451920 19.500 99 67 131 1 2028658224 24511104 19695200
20:39:41 3931 8192000000 10957502080 11387273216 2001422720 19.634 100 69 136 2 2047382768 25201872 20758176
20:39:53 6846 8192000000 10980401648 11401187328 2010780560 19.708 100 77 154 1 2058326208 25617264 21928384
20:40:08 7110 8192000000 10968888048 11393363968 2006093440 19.671 100 79 158 2 2056852704 27685232 23074032
20:40:23 900 8192000000 10980091024 11392536576 2002236832 19.640 100 89 178 0 2059655216 31358624 26059760
20:40:30 1762 8192000000 10974435584 11396554752 2004851248 19.661 100 89 178 0 2062719984 31686800 26181936
20:40:39 2114 8192000000 10972168832 11387957248 1989480160 19.540 99 92 182 3 2046885072 29929680 27475232
20:40:49 6558 8192000000 10931075968 11345932288 1935591792 19.112 97 81 160 2 1994251488 35028848 23630848
20:41:03 5757 8192000000 10930389312 11351678976 1962149680 19.323 100 71 141 0 2018293920 35424704 20719536
20:41:15 9180 8192000000 10945005536 11365851136 1973000352 19.409 100 69 138 1 2026293120 32058304 21234464
20:41:31 3805 8192000000 10925616688 11347722240 1947588384 19.207 99 73 146 2 2005138560 34819984 22730192
20:41:43 4658 8192000000 10944728080 11366850560 1970881440 19.392 100 68 133 0 2028726496 37291632 20553424
20:41:54 1806 8192000000 10958860560 11369590784 1962009280 19.322 99 75 149 3 2022311360 37717088 22584992
20:42:06 5901 8192000000 10955579456 11380776960 1980072432 19.465 100 77 154 1 2042864688 38970000 23822256
20:42:25 7436 8192000000 10958647808 11389165568 1983395760 19.492 100 59 116 1 2043478720 41718736 18364224
20:42:40 5134 8192000000 10963663936 11390844928 1990938800 19.551 100 68 137 2 2051106128 39112128 21055200
20:42:54 2054 8192000000 10949901376 11366866944 1943586208 19.175 98 88 176 2 2007343824 36354960 27402656
20:43:03 5112 8192000000 10951346304 11374129152 1978242816 19.451 100 74 148 1 2038203408 37654560 22306032
20:43:16 2256 8192000000 10964126576 11382468608 1986761808 19.518 100 77 154 0 2047652544 37881456 23009280
20:43:28 4822 8192000000 10940952128 11362578432 1957977072 19.290 99 74 147 1 2020844256 40015936 22851248
20:43:41 3658 8192000000 10966050832 11374092288 1974776944 19.423 100 87 172 2 2041134352 40281088 26076320
20:43:51 3955 8192000000 10944174912 11362656256 1961071312 19.315 99 75 150 0 2025059040 40665472 23322256
20:44:05 2976 8192000000 10942966928 11364937728 1964607424 19.343 99 76 151 0 2027941712 40398192 22936096
20:44:22 3667 8192000000 10950841024 11369222144 1969343360 19.380 100 74 146 2 2033367488 41851520 22172608
20:44:34 2146 8192000000 10975675552 11385032704 1988240256 19.530 100 90 180 2 2057683600 41657920 27785424
20:44:44 3306 8192000000 10979561040 11388948480 1985813552 19.511 100 86 171 2 2055439776 44447152 25179072
20:44:54 1870 8192000000 10958986304 11365892096 1967510464 19.366 99 90 180 2 2040913040 46044720 27357856
20:45:02 3498 8192000000 10965026752 11374977024 1976441056 19.437 100 86 172 1 2047902160 45742800 25718304
20:45:17 1881 8192000000 10975113776 11383115776 1981705040 19.478 100 94 189 0 2055709472 45858656 28145776
20:45:26 3163 8192000000 10971880992 11389763584 1987425136 19.523 100 75 147 3 2058875328 48930480 22519712
20:45:37 2405 8192000000 10978765120 11397468160 1994966672 19.583 100 82 164 2 2070000160 48998320 26035168
20:45:48 3234 8192000000 10979685632 11395772416 1989249776 19.538 100 80 161 1 2062561040 48577744 24733520
20:45:59 2087 8192000000 10956507344 11365146624 1959968720 19.306 99 71 142 3 2031645184 49655008 22021456
20:46:07 6687 8192000000 10971849568 11390242816 1983583840 19.493 100 82 164 1 2057592192 48856400 25151952
20:46:25 1544 8192000000 10986553728 11400359936 1994483664 19.579 100 82 165 1 2069171808 49543792 25144352
20:46:35 1642 8192000000 10982963952 11389825024 1980384752 19.468 100 88 176 2 2060210768 52563200 27262816
20:46:44 4370 8192000000 10969603520 11379265536 1957099632 19.283 99 84 167 2 2036913328 54142608 25671088
20:46:56 1388 8192000000 10971211072 11375407104 1972323888 19.404 100 91 179 0 2054781008 54664832 27792288
20:47:04 2903 8192000000 10972084976 11377565696 1968932896 19.377 100 88 176 2 2051767824 55196576 27638352
20:47:17 1149 8192000000 10951465136 11357581312 1948663360 19.216 99 89 175 1 2031894512 55370640 27860512
20:47:26 2632 8192000000 10971113952 11375882240 1964760720 19.344 100 89 177 2 2048914768 56184128 27969920
20:47:38 2522 8192000000 10957093312 11363700736 1948284736 19.213 99 83 166 2 2030817312 56043728 26488848
20:47:47 2884 8192000000 10966519328 11375861760 1952961104 19.250 99 83 162 0 2033365552 54634384 25770064
20:47:57 795 8192000000 10964350944 11370717184 1961987024 19.322 100 88 177 4 2045567984 55527648 28053312
20:48:06 4644 8192000000 10971356368 11385769984 1969719904 19.383 100 76 151 0 2052020672 58336416 23964352
20:48:23 3383 8192000000 10970507664 11386167296 1971181424 19.395 100 70 141 1 2051267680 57723744 22362512
20:48:33 7088 8192000000 10959221808 11384913920 1966094032 19.354 100 56 112 2 2042902832 58190448 18618352
20:48:47 10533 8192000000 10935082608 11365679104 1927449600 19.046 98 44 87 0 1997287216 55156336 14681280
20:49:09 3690 8192000000 10949374864 11369238528 1945238704 19.189 99 61 122 1 2016131536 51338224 19554608
20:49:20 5852 8192000000 10952314640 11374440448 1963585904 19.335 100 62 124 1 2036450224 53017024 19847296
20:49:52 30721 8192000000 10932796544 11366481920 1922203664 19.004 98 43 86 1 1995000672 57915392 14881616
20:50:33 4526 8192000000 10949344416 11375276032 1959850288 19.305 100 60 121 3 2036034912 57067456 19117168
20:50:48 2637 8192000000 10951253520 11373850624 1961371232 19.317 100 58 114 3 2029468064 49756432 18340400
20:51:00 4783 8192000000 10947414640 11375824896 1959159984 19.299 100 59 119 1 2031225728 53077936 18987808
20:51:24 12662 8192000000 10950636736 11389382656 1966031344 19.354 100 40 80 2 2033493136 53813120 13648672
20:51:44 18296 8192000000 10951103392 11399475200 1967646896 19.367 100 36 72 1 2039864144 59556928 12660320
20:52:24 23300 8192000000 10951266576 11394674688 1964201696 19.339 100 34 68 0 2038151328 61894128 12055504
20:53:07 17762 8192000000 10946346160 11398590464 1964483376 19.342 100 35 69 0 2035953232 58822208 12647648
20:53:42 22489 8192000000 10942486320 11396030464 1951027440 19.235 100 32 64 0 2030091248 66970048 12093760
20:54:28 19311 8192000000 10933668336 11389046784 1939046400 19.139 100 27 54 0 2015981568 65937760 10997408
20:54:54 7378 8192000000 10951092992 11392909312 1944352304 19.181 100 42 84 1 2028681984 68559104 15770576
20:55:08 29662 8192000000 10939945808 11404836864 1944646400 19.184 100 29 58 2 2025673040 69160784 11865856
20:55:54 52902 8192000000 10838919568 11310260224 1809821504 18.094 94 17 34 0 1877610912 61659104 6130304
20:56:53 56950 8192000000 10862188432 11317833728 1902306800 18.845 99 11 22 1 1914424080 8936032 3181248
20:58:02 58682 8192000000 10872376208 11333488640 1927678160 19.048 99 12 24 1 1944092032 13511232 2902640
20:59:20 29286 8192000000 10885860688 11333296128 1953596816 19.255 100 40 80 0 1973102432 8009120 11496496
21:00:00 59004 8192000000 10881380304 11342159872 1950641952 19.232 100 14 28 1 1967800592 12856672 4301968
21:01:07 71423 8192000000 10876422080 11346968576 1914818864 18.945 98 10 20 0 1931906896 14458896 2629136
21:02:34 61455 8192000000 10890228160 11345317888 1923448816 19.014 98 13 26 0 1935581152 8555312 3577024
21:03:51 128914 8192000000 10890432384 11346788352 1900446288 18.830 97 28 57 1 1922314960 13628720 8239952
21:06:32 83013 8192000000 10904335392 11367002112 1959157296 19.299 100 22 44 0 1983467216 17917040 6392880
21:09:42 58149 8192000000 10897431104 11358785536 1965060176 19.346 100 11 22 0 1975518096 7714400 2743520
21:10:52 46804 8192000000 10931929728 11365113856 1954604864 19.263 99 24 47 0 1969898016 7898064 7395088
21:11:45 18246 8192000000 10905024784 11368439808 1973902928 19.416 100 25 51 1 1990123344 9317040 6903376
21:12:10 73219 8192000000 10894651360 11367112704 1941086672 19.155 98 13 26 0 1954884272 10082256 3715344
21:13:32 134788 8192000000 10916998336 11391107072 1940270592 19.149 98 6 12 0 1954616768 12918320 1427856
21:16:01 117354 8192000000 10923720208 11373936640 1950348656 19.229 98 21 42 0 1971451968 15153008 5950304
21:18:04 121033 8192000000 10912138624 11369758720 1929015424 19.059 97 32 64 0 1955207472 15905392 10286656
21:20:15 116776 8192000000 10914976928 11390042112 1980731376 19.470 100 24 48 2 2008354032 20889728 6732928
21:22:18 7118 8192000000 10922099008 11394641920 1988268864 19.530 100 14 28 0 2008597216 16641728 3686624
21:22:32 2277 8192000000 10947936704 11393679360 1996484064 19.595 100 48 97 2 2020437728 10585984 13367680
21:22:42 23103 8192000000 10925004320 11396370432 1995843936 19.590 100 38 74 1 2021783888 14498736 11441216
21:23:32 53882 8192000000 10929030464 11382300672 1956029248 19.274 98 23 44 2 1974702688 11773344 6900096
21:24:32 22219 8192000000 10917546208 11373772800 1965016992 19.346 99 42 84 0 1990029760 10618448 14394320
21:25:12 48319 8192000000 10912505440 11370041344 1963201120 19.331 99 31 62 1 1983578784 11286800 9090864
21:26:10 107054 8192000000 10897511824 11368288256 1942094544 19.163 98 20 40 1 1955652640 8148016 5410080
21:28:06 40411 8192000000 10884155056 11359285248 1955774752 19.272 99 8 16 1 1966744192 9152416 1817024
21:28:52 14061 8192000000 10887302048 11360755712 1971061872 19.394 100 9 18 0 1982199344 9265840 1871632
21:29:15 14726 8192000000 10886980432 11357847552 1949076048 19.219 99 12 24 0 1964419952 12399248 2944656
21:29:39 34076 8192000000 10883141120 11361112064 1953333456 19.253 99 9 18 0 1963439824 8384288 1722080
21:30:19 37940 8192000000 10896394944 11367305216 1976406576 19.436 100 16 31 1 1987638144 6859520 4372048
21:31:03 41682 8192000000 10858320512 11335405568 1872765600 18.607 95 13 24 0 1882625104 6919280 2940224
21:31:51 48704 8192000000 10875837904 11351232512 1931567872 19.079 99 18 36 0 1948618576 12575040 4475664
21:32:47 32475 8192000000 10873361440 11357446144 1933977840 19.099 99 8 16 0 1949936752 13709088 2249824
21:33:30 40357 8192000000 10860966048 11333189632 1872744336 18.606 96 7 14 1 1889842000 15393824 1703840
21:34:30 48640 8192000000 10848056368 11316727808 1798041008 17.998 92 21 42 0 1813629344 8856928 6731408
21:35:27 50516 8192000000 10856783472 11333148672 1897140320 18.803 98 33 66 1 1923403648 16395792 9867536
21:36:55 56037 8192000000 10892163824 11346780160 1897365168 18.805 98 24 47 1 1917501920 13616176 6520576
21:37:59 21195 8192000000 10870083600 11317919744 1881001600 18.673 97 41 82 2 1902245408 9716032 11527776
21:38:29 33273 8192000000 10867126080 11327569920 1911503568 18.919 99 45 90 1 1935086960 10856608 12726784
21:40:00 11578 8192000000 10876135536 11314847744 1917469536 18.967 100 57 113 2 1940519488 6527920 16522032
21:40:22 28133 8192000000 10855994976 11315093504 1904190960 18.860 99 36 71 0 1927459472 13513184 9755328
21:41:07 45922 8192000000 10851290640 11312775168 1870013344 18.584 97 21 42 2 1889819392 13628272 6177776
21:42:06 55124 8192000000 10886471328 11329908736 1898588800 18.815 99 9 20 1 1909807856 9117760 2101296
21:43:07 97834 8192000000 10876542272 11334131712 1881201360 18.675 97 17 34 2 1900224208 14266096 4756752
21:44:56 69282 8192000000 10863123872 11335892992 1861741376 18.517 96 9 18 1 1877627488 13757632 2128480
21:46:13 126556 8192000000 10857844288 11335581696 1851801968 18.437 96 24 48 2 1875303728 17052512 6449248
21:48:47 59867 8192000000 10858645888 11320147968 1878826352 18.656 97 30 60 0 1895546704 7948848 8771504
21:49:53 55193 8192000000 10861806432 11322662912 1913557008 18.935 99 40 80 0 1939818304 15010096 11251200
21:50:55 42143 8192000000 10847707408 11326767104 1929153760 19.060 100 35 68 1 1952238080 13445216 9639104
21:51:51 57405 8192000000 10860931840 11345485824 1934341424 19.102 100 17 32 2 1954478080 15120688 5015968
21:53:05 55967 8192000000 10856950688 11341611008 1938873184 19.138 100 9 18 0 1953121424 11306704 2941536
21:54:10 47737 8192000000 10847166064 11326144512 1903378544 18.853 98 22 42 3 1915843104 6569264 5895296
21:55:04 52083 8192000000 10866968192 11341508608 1937550416 19.127 100 15 30 1 1950947872 9057024 4340432
21:56:25 57950 8192000000 10874925664 11349385216 1931232384 19.077 99 18 36 0 1943749856 7265728 5251744
21:57:38 24720 8192000000 10893728128 11355881472 1961326176 19.317 100 17 34 0 1974164080 8141488 4696416
21:58:11 50714 8192000000 10884109872 11358294016 1947186064 19.204 99 18 36 1 1963571376 11582560 4802752
21:59:29 64863 8192000000 10884849360 11376320512 1961239584 19.316 100 18 37 1 1979640416 12963056 5437776
22:01:45 43171 8192000000 10905121216 11381547008 1964247904 19.340 99 21 42 0 1979753552 9562896 5942752
22:02:42 103008 8192000000 10898908480 11384360960 1930842192 19.074 97 19 38 1 1948705728 12232224 5631312
22:04:34 70779 8192000000 10925936208 11398549504 1965401904 19.349 99 23 46 1 1982763392 10631200 6730288
22:05:51 45612 8192000000 10916374096 11378634752 1938004896 19.131 97 35 70 0 1960434912 13032528 9397488
22:06:51 133641 8192000000 10904762848 11400769536 1898136112 18.811 96 13 26 1 1916046304 14384192 3526000
22:09:13 57437 8192000000 10905862624 11382353920 1941435504 19.158 98 9 18 0 1953256352 9746320 2074528
22:10:17 37070 8192000000 10919172672 11388780544 1950516640 19.231 98 24 48 1 1967022624 9642928 6863056
22:11:04 83956 8192000000 10934308256 11381145600 1929974480 19.067 97 19 38 1 1944916112 9063456 5878176
22:12:35 17303 8192000000 10926791360 11381854208 1960010592 19.306 99 45 91 1 1984332160 11900240 12421328
22:13:03 12807 8192000000 10920092688 11376472064 1954536496 19.263 99 47 93 2 1978569696 11553088 12480112
22:13:22 12821 8192000000 10936337184 11396026368 1983936912 19.496 100 46 92 2 2009287888 12740112 12610864
22:13:41 8011 8192000000 10915979440 11378225152 1964182656 19.339 99 36 72 0 1984720832 10455728 10082448
22:14:03 110568 8192000000 10904903552 11374051328 1974972528 19.425 100 35 70 2 1993498816 8918944 9607344
22:16:02 48309 8192000000 10868151792 11356155904 1930023792 19.067 98 11 20 1 1940241568 7139328 3078448
22:16:56 41008 8192000000 10865051264 11352137728 1920944208 18.994 98 8 16 0 1929288384 6526384 1817792
22:17:43 75950 8192000000 10850746752 11330117632 1880391536 18.668 96 9 19 0 1888849744 6171840 2286368
22:19:08 79818 8192000000 10896596768 11375439872 1958825728 19.297 100 16 32 0 1974617760 11163728 4628304
22:21:19 74692 8192000000 10868877056 11361546240 1903968752 18.858 97 8 16 1 1918713488 12336560 2408176
22:22:40 68771 8192000000 10884408544 11360583680 1905011856 18.867 97 16 33 1 1919841392 10322144 4507392
22:24:11 47037 8192000000 10874221248 11340181504 1875082432 18.625 96 25 50 0 1893045472 10517824 7445216
22:25:05 77085 8192000000 10872273408 11345518592 1875867696 18.632 96 19 38 1 1896137664 14694288 5575680
22:26:48 48902 8192000000 9119618048 9351540736 290353040 3.423 15 8 14 1 302228560 9257824 2617696

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 21-02-2021 22:29:00 to 21-02-2021 22:29:32.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 96 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 21-02-2021 22:29:33 to 21-02-2021 22:29:35.

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          239347
MON$OLDEST_ACTIVE               239348
MON$OLDEST_SNAPSHOT             239348
MON$NEXT_TRANSACTION            239348
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                       2043296
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.33420 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33420 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33420 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33420 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 ---
:116: 
:117: mscs-test-161.budzdorov.ru    Sun Feb 21 22:27:47 2021
:118:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:119: 
:120: 
:121: mscs-test-161.budzdorov.ru    Sun Feb 21 22:28:13 2021
:122:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:123: 
--- end of diff output ---

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

21.02.21 22:29:36. 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-02-21 22:29:38 No severe PSQL-related problems occured
21.02.21 22:29:39. End of report.