Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 04.04.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 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 17279100 kB
MemAvailable 31468768 kB
Buffers 0 kB
Cached 14413728 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-04-04 22:27:28
DTS_END                         2021-04-04 22:27:28.0650
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/36670
TRN_ID                          237776
ATT_ID                          708
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: 9231.32 23752 1107758
customer order: creation 164.45 372 19734
customer order: refuse 14.11 377 1693
order to supplier: creation 44.81 1391 5377
order to supplier: removal 3.38 110974 406
invoice (draft): creation 44.56 3364 5347
invoice (draft): removal 54.53 930 6544
invoice accept: apply 40.19 18024 4823
invoice accept: cancel 49.08 795 5889
customer reserve: creation 3704.68 176 444562
customer reserve: removal 4816.68 59 578002
realization accept: apply 79.78 187 9573
realization accept: cancel 89.58 102 10750
payment from customer: creation 57.27 141 6872
payment from customer: removal 5.74 90 689
payment to supplier: creation 47.28 144 5673
payment to supplier: removal 3.03 74 363
service: total inventory turnovers 4.47 1133 537
service: total monetary turnovers 6.88 27 826
service: aggregate perf. data 0.78 23427 94
service: refresh index statistics 0.03 313254 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 04-04-2021 22:29:02 to 04-04-2021 22:29:04.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2155
TEST_TIME 2 3086
TEST_TIME 3 4060
TEST_TIME 4 4384
TEST_TIME 5 4540
TEST_TIME 6 4323
TEST_TIME 7 4453
TEST_TIME 8 4506
TEST_TIME 9 5051
TEST_TIME 10 5046
TEST_TIME 11 5407
TEST_TIME 12 5686
TEST_TIME 13 5718
TEST_TIME 14 6015
TEST_TIME 15 6421
TEST_TIME 16 6835
TEST_TIME 17 7389
TEST_TIME 18 7267
TEST_TIME 19 7629
TEST_TIME 20 7953
TEST_TIME 21 7995
TEST_TIME 22 8390
TEST_TIME 23 8755
TEST_TIME 24 8911
TEST_TIME 25 9354
TEST_TIME 26 9937
TEST_TIME 27 10109
TEST_TIME 28 11149
TEST_TIME 29 11140
TEST_TIME 30 10944
TEST_TIME 31 10703
TEST_TIME 32 10493
TEST_TIME 33 10584
TEST_TIME 34 10522
TEST_TIME 35 10362
TEST_TIME 36 10199
TEST_TIME 37 10106
TEST_TIME 38 9924
TEST_TIME 39 9924
TEST_TIME 40 9890
TEST_TIME 41 9748
TEST_TIME 42 9723
TEST_TIME 43 9811
TEST_TIME 44 9814
TEST_TIME 45 9743
TEST_TIME 46 9622
TEST_TIME 47 9850
TEST_TIME 48 9691
TEST_TIME 49 9659
TEST_TIME 50 9535
TEST_TIME 51 9405
TEST_TIME 52 9576
TEST_TIME 53 9560
TEST_TIME 54 9484
TEST_TIME 55 9578
TEST_TIME 56 9536
TEST_TIME 57 9474
TEST_TIME 58 9548
TEST_TIME 59 9557
TEST_TIME 60 9613
TEST_TIME 61 9598
TEST_TIME 62 9655
TEST_TIME 63 9708
TEST_TIME 64 9799
TEST_TIME 65 9809
TEST_TIME 66 9854
TEST_TIME 67 9838
TEST_TIME 68 9838
TEST_TIME 69 9748
TEST_TIME 70 9699
TEST_TIME 71 9671
TEST_TIME 72 9587
TEST_TIME 73 9590
TEST_TIME 74 9590
TEST_TIME 75 9556
TEST_TIME 76 9548
TEST_TIME 77 9493
TEST_TIME 78 9420
TEST_TIME 79 9356
TEST_TIME 80 9315
TEST_TIME 81 9374
TEST_TIME 82 9364
TEST_TIME 83 9354
TEST_TIME 84 9372
TEST_TIME 85 9430
TEST_TIME 86 9468
TEST_TIME 87 9472
TEST_TIME 88 9433
TEST_TIME 89 9413
TEST_TIME 90 9513
TEST_TIME 91 9553
TEST_TIME 92 9522
TEST_TIME 93 9540
TEST_TIME 94 9604
TEST_TIME 95 9596
TEST_TIME 96 9521
TEST_TIME 97 9476
TEST_TIME 98 9467
TEST_TIME 99 9407
TEST_TIME 100 9373
TEST_TIME 101 9393
TEST_TIME 102 9372
TEST_TIME 103 9379
TEST_TIME 104 9371
TEST_TIME 105 9341
TEST_TIME 106 9300
TEST_TIME 107 9296
TEST_TIME 108 9339
TEST_TIME 109 9354
TEST_TIME 110 9403
TEST_TIME 111 9386
TEST_TIME 112 9430
TEST_TIME 113 9432
TEST_TIME 114 9382
TEST_TIME 115 9371
TEST_TIME 116 9352
TEST_TIME 117 9324
TEST_TIME 118 9282
TEST_TIME 119 9255
TEST_TIME 120 9233

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 04-04-2021 22:29:05 to 04-04-2021 22:29:09.

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 1520703 1520703 0 0.00 0 19958 6 0 0
doc_list_biud 1520703 1520703 0 0.00 0 56851 29 0 0
sp_add_invoice_to_stock 4952 4823 129 2.60 42 164161 18024 0 129
sp_cancel_adding_invoice 5889 5889 0 0.00 5 41393 796 0 0
sp_cancel_client_order 1693 1693 0 0.00 5 16116 377 0 0
sp_cancel_customer_reserve 578002 578002 0 0.00 1 56854 59 0 0
sp_cancel_pay_from_customer 689 689 0 0.00 3 6991 91 0 0
sp_cancel_pay_to_supplier 363 363 0 0.00 3 4407 75 0 0
sp_cancel_supplier_invoice 6552 6544 8 0.12 2 44744 931 0 8
sp_cancel_supplier_order 406 406 0 0.00 7 978716 110974 0 0
sp_cancel_write_off 10750 10750 0 0.00 1 9398 102 0 0
sp_client_order 19734 19734 0 0.00 3 54288 372 0 0
sp_customer_reserve 444562 444562 0 0.00 0 49185 177 0 0
sp_fill_shopping_cart 30456 30456 0 0.00 1 24493 39 0 0
sp_fill_shopping_cart_clo_res 444551 444551 0 0.00 0 37720 15 0 0
sp_get_clo_for_invoice 4812 4812 0 0.00 0 43567 387 0 0
sp_kill_cost_storno 17691 17691 0 0.00 0 15357 59 0 0
sp_kill_qstorno_ret_qs2qd 1173704 1173704 0 0.00 0 56847 33 0 0
sp_kill_qty_storno 617669 617669 0 0.00 0 56851 71 0 0
sp_lock_selected_doc 20027 20027 0 0.00 0 7880 5 0 0
sp_make_cost_storno 26930 26930 0 0.00 0 19950 57 0 0
sp_multiply_rows_for_pdistr 26930 26930 0 0.00 0 7514 30 0 0
sp_multiply_rows_for_qdistr 19734 19734 0 0.00 0 54251 157 0 0
sp_pay_from_customer 6872 6872 0 0.00 4 15536 141 0 0
sp_pay_to_supplier 5673 5673 0 0.00 5 14676 145 0 0
sp_payment_common 12545 12545 0 0.00 1 15011 28 0 0
sp_qd_handle_on_cancel_clo 1693 1693 0 0.00 0 16111 342 0 0
sp_qd_handle_on_invoice_upd_sts 10701 10701 0 0.00 0 40020 362 0 0
sp_qd_handle_on_reserve_upd_sts 9573 9573 0 0.00 0 23445 63 0 0
sp_reserve_write_off 9573 9573 0 0.00 6 24145 187 0 0
sp_supplier_invoice 5347 5347 0 0.00 6 75741 3365 0 0
sp_supplier_order 5377 5377 0 0.00 6 95214 1392 0 0
srv_aggregate_perf_data 94 94 0 0.00 2487 263807 23427 0 0
srv_fill_mon_cache_memory 155 155 0 0.00 1030 203701 34337 0 0
srv_find_qd_qs_mism 1062394 1062394 0 0.00 0 16931 5 0 0
srv_make_invnt_saldo 537 537 0 0.00 44 47159 1133 0 0
srv_make_money_saldo 826 826 0 0.00 1 2482 28 0 0
srv_recalc_idx_stat 4 4 0 0.00 145215 427256 313254 0 0
t$perf-abend:sp_add_invoice_to_stock 129 129 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 4823 4823 0 0.00 0 34743 178 0 0
t$perf-norm:sp_cancel_adding_invoice 424 424 0 0.00 1 5723 119 0 0
t$perf-norm:sp_cancel_client_order 1693 1693 0 0.00 0 3191 14 0 0
t$perf-norm:sp_cancel_customer_reserve 646 646 0 0.00 0 11692 41 0 0
t$perf-norm:sp_cancel_pay_from_customer 689 689 0 0.00 0 2057 9 0 0
t$perf-norm:sp_cancel_pay_to_supplier 363 363 0 0.00 0 695 6 0 0
t$perf-norm:sp_cancel_supplier_invoice 426 426 0 0.00 0 646 17 0 0
t$perf-norm:sp_cancel_supplier_order 406 406 0 0.00 0 42048 1840 0 0
t$perf-norm:sp_cancel_write_off 996 996 0 0.00 0 5420 25 0 0
t$perf-norm:sp_client_order 19734 19734 0 0.00 0 19452 20 0 0
t$perf-norm:sp_customer_reserve 996 996 0 0.00 0 1926 6 0 0
t$perf-norm:sp_pay_from_customer 6872 6872 0 0.00 0 9502 14 0 0
t$perf-norm:sp_pay_to_supplier 5673 5673 0 0.00 0 7014 11 0 0
t$perf-norm:sp_reserve_write_off 9573 9573 0 0.00 0 7611 16 0 0
t$perf-norm:sp_supplier_invoice 5347 5347 0 0.00 0 6945 19 0 0
t$perf-norm:sp_supplier_order 5377 5377 0 0.00 0 16991 23 0 0
t$perf-norm:srv_aggregate_perf_data 94 94 0 0.00 0 187 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 155 155 0 0.00 0 351 6 0 0
t$perf-norm:srv_make_invnt_saldo 537 537 0 0.00 0 2257 28 0 0
t$perf-norm:srv_make_money_saldo 826 826 0 0.00 0 2799 15 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 3 3 0 0
v_add_invoice_to_stock 9882 9624 258 2.61 0 6539 21 0 258
v_all_customers 36502 36502 0 0.00 0 19 1 0 0
v_all_suppliers 30082 30082 0 0.00 0 18 1 0 0
v_all_wares 39466 39466 0 0.00 0 18 1 0 0
v_cancel_adding_invoice 848 848 0 0.00 0 1572 9 0 0
v_cancel_client_order 3386 3386 0 0.00 0 2970 6 0 0
v_cancel_customer_prepayment 1378 1378 0 0.00 0 5591 15 0 0
v_cancel_customer_reserve 1292 1292 0 0.00 0 4668 11 0 0
v_cancel_payment_to_supplier 726 726 0 0.00 0 1764 7 0 0
v_cancel_supplier_invoice 868 852 16 1.84 0 4465 26 0 16
v_cancel_supplier_order 812 812 0 0.00 0 1465 6 0 0
v_cancel_write_off 1992 1992 0 0.00 0 7143 21 0 0
v_max_id_clo_ord 5376 5376 0 0.00 0 716 1 0 0
v_max_id_clo_res 996 996 0 0.00 0 1624 10 0 0
v_max_id_ord_sup 5347 5347 0 0.00 0 6129 7 0 0
v_max_non_paid_invoice 1353 1353 0 0.00 0 2527 4 0 0
v_max_non_paid_realizn 3465 3465 0 0.00 0 2359 6 0 0
v_min_id_clo_ord 5376 5376 0 0.00 0 4356 7 0 0
v_min_id_clo_res 996 996 0 0.00 0 3434 11 0 0
v_min_id_ord_sup 5347 5347 0 0.00 0 6075 10 0 0
v_min_non_paid_invoice 5673 5673 0 0.00 0 5868 16 0 0
v_min_non_paid_realizn 6872 6872 0 0.00 0 7073 16 0 0
v_our_firm 9778 9778 0 0.00 0 20 1 0 0
v_reserve_write_off 19144 19144 0 0.00 0 4823 6 0 0
x_lock_depdocs_on_canc_invoice 12007 12007 0 0.00 0 13601 119 0 0
x_lock_depdocs_on_canc_sup_ord 406 406 0 0.00 0 22519 399 0 0
x_make_qstorno_1000_1200 5377 5377 0 0.00 2 95159 1306 0 0
x_make_qstorno_1200_2000 5347 5347 0 0.00 3 75678 3231 0 0
x_make_qstorno_2100_3300 444562 444562 0 0.00 0 43036 160 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 04-04-2021 22:29:10 to 04-04-2021 22:29:14.

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:31 2 8192000000 8799342608 8810168320 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:38 13124 8192000000 10224607488 10525057024 943284752 10.325 74 59 121 0 964514816 2358528 18871536
19:57:59 31602 8192000000 10351479552 10663731200 1368372032 14.312 100 79 157 1 1397654336 4445136 24837168
19:58:39 29277 8192000000 10377887968 10700095488 1432135440 14.880 100 80 160 0 1463804976 5884928 25784608
19:59:20 20581 8192000000 10402881280 10728067072 1459642176 15.123 100 91 182 0 1496264784 6827552 29795056
19:59:53 24095 8192000000 10423467056 10751172608 1475094544 15.258 100 91 182 0 1512550288 7688544 29767200
20:00:29 20763 8192000000 10443432272 10780020736 1500169840 15.478 100 86 172 0 1536059776 8161280 27728656
20:01:04 23336 8192000000 10469984128 10807291904 1524404944 15.688 100 86 172 0 1560589008 8827456 27356608
20:01:35 20669 8192000000 10483107440 10827075584 1537182624 15.799 100 80 160 0 1571378512 9177968 25017920
20:02:04 13765 8192000000 10482256032 10837626880 1551329456 15.921 100 69 138 0 1582499200 9424016 21745728
20:02:32 16248 8192000000 10538106576 10893271040 1589711824 16.251 100 72 144 0 1621144688 9807040 21625824
20:02:57 16108 8192000000 10572702368 10935640064 1627617392 16.575 100 79 158 2 1662846672 11349872 23879408
20:03:32 11411 8192000000 10604731216 10969038848 1658865104 16.839 100 77 155 1 1693446368 11942816 22638448
20:03:49 9998 8192000000 10625210960 10989289472 1678367152 17.004 100 81 162 1 1714902464 13130304 23405008
20:04:09 8170 8192000000 10644618432 11014725632 1693757616 17.133 100 83 166 1 1730646432 13014864 23873952
20:04:25 7233 8192000000 10658001696 11028119552 1718256944 17.338 100 79 158 0 1753540576 12243840 23039792
20:04:41 6983 8192000000 10678309808 11051155456 1730222384 17.437 100 87 174 0 1768487520 13084240 25180896
20:04:55 5563 8192000000 10687750368 11062845440 1746503184 17.573 100 84 168 1 1783817696 13537824 23776688
20:05:08 5691 8192000000 10697553056 11071758336 1753579264 17.631 100 81 161 1 1790713472 14015184 23119024
20:05:21 4701 8192000000 10693328368 11072905216 1762057504 17.701 100 80 158 3 1798372240 13735072 22579664
20:05:32 3962 8192000000 10720699216 11096723456 1771537120 17.780 100 86 172 2 1810115264 14372736 24205408
20:05:43 4622 8192000000 10725933760 11104911360 1779840768 17.848 100 81 160 2 1815865408 13224192 22800448
20:05:55 5141 8192000000 10732178432 11116429312 1795009024 17.973 100 82 164 0 1830551840 12864176 22678640
20:06:07 3370 8192000000 10734060864 11122606080 1806389600 18.066 100 83 166 0 1843298672 13392304 23516768
20:06:17 4694 8192000000 10745356944 11131301888 1807137264 18.072 100 88 173 1 1845279792 13667232 24475296
20:06:29 2597 8192000000 10754566656 11135660032 1815463712 18.141 100 83 163 1 1850289360 12819248 22006400
20:06:38 3524 8192000000 10758328096 11144708096 1821452528 18.190 100 83 166 1 1856816544 13053520 22310496
20:06:49 8778 8192000000 10766286304 11150950400 1825125392 18.220 100 79 157 2 1859709744 12588912 21995440
20:07:04 2053 8192000000 10768278832 11157323776 1833633904 18.289 100 82 162 1 1868801776 12960320 22207552
20:07:14 2625 8192000000 10791938704 11176505344 1845550080 18.386 100 96 193 1 1885178464 12715072 26913312
20:07:23 2080 8192000000 10793398960 11180052480 1851433856 18.434 100 88 176 0 1889941776 14056864 24451056
20:07:32 1859 8192000000 10799625904 11183595520 1853807808 18.453 100 92 186 1 1894293024 14035104 26450112
20:07:40 2568 8192000000 10805286896 11190415360 1855711136 18.468 100 90 179 1 1893715792 13133552 24871104
20:07:49 3063 8192000000 10807972880 11199361024 1863444160 18.531 100 94 186 0 1904284592 15535600 25304832
20:07:59 1400 8192000000 10810310528 11198316544 1870897664 18.592 100 95 190 2 1911838240 13924928 27015648
20:08:06 2600 8192000000 10812083888 11202129920 1870887072 18.591 100 87 174 1 1908119888 13063008 24169808
20:08:15 1737 8192000000 10818364720 11208105984 1871410432 18.596 100 91 182 2 1910904944 14116480 25378032
20:08:23 1488 8192000000 10819054336 11207888896 1872518976 18.605 100 90 180 1 1912231072 13554592 26157504
20:08:31 1589 8192000000 10816577456 11207536640 1875421840 18.628 100 85 170 2 1913131456 12347504 25362112
20:08:39 1963 8192000000 10825741184 11221454848 1881190608 18.675 100 84 168 1 1918131376 13320832 23619936
20:08:47 17992 8192000000 10826153040 11217440768 1877965840 18.649 100 69 139 1 1907565344 9531808 20067696
20:09:12 6508 8192000000 10811279440 11218808832 1877772448 18.647 100 35 70 1 1895650512 8137632 9740432
20:09:26 3563 8192000000 10795566288 11219243008 1883162960 18.691 100 42 84 0 1904097584 9120048 11814576
20:09:36 6117 8192000000 10793209008 11216908288 1881482592 18.677 100 33 66 2 1899109616 8239520 9387504
20:09:49 4465 8192000000 10787103856 11213774848 1882399664 18.684 100 35 70 1 1899425872 6459664 10566544
20:10:04 5837 8192000000 10799570608 11222847488 1884325520 18.700 100 38 74 1 1901502960 6704352 10473088
20:10:18 6995 8192000000 10790008000 11221381120 1884506976 18.701 100 22 44 3 1905965008 15669760 5788272
20:10:32 9932 8192000000 10792049264 11223080960 1886759168 18.720 100 30 61 1 1902371216 7503280 8108768
20:10:51 6849 8192000000 10800887920 11227881472 1888015104 18.730 100 33 64 3 1903882432 6929408 8937920
20:11:05 9994 8192000000 10792457168 11222736896 1887245472 18.724 100 26 52 0 1900869872 6359808 7264592
20:11:23 6664 8192000000 10801378432 11235139584 1890363216 18.749 100 31 59 1 1909056096 10707104 7985776
20:11:39 8279 8192000000 10792854032 11227590656 1893369328 18.773 100 21 41 1 1904461680 5476064 5616288
20:11:58 14846 8192000000 10801625872 11237085184 1891861664 18.761 100 16 32 0 1901930720 5468224 4600832
20:12:20 76336 8192000000 10813870032 11247714304 1894983312 18.786 100 25 49 2 1908177200 6058368 7135520
20:13:47 5105 8192000000 10824205520 11252969472 1899912064 18.826 100 34 67 0 1916219296 6900656 9406576
20:14:00 4305 8192000000 10829940208 11255975936 1902003808 18.842 100 34 68 1 1919062240 7692768 9365664
20:14:12 4425 8192000000 10826052816 11253309440 1901279008 18.837 100 31 61 0 1915812880 5475440 9058432
20:14:24 3312 8192000000 10833937088 11256975360 1908709424 18.896 100 46 94 0 1928685888 6020192 13956272
20:14:34 7047 8192000000 10811761584 11248668672 1895520944 18.790 100 21 43 1 1907879872 6338128 6020800
20:14:49 8789 8192000000 10821649760 11252584448 1897891200 18.809 100 18 34 3 1908007840 5626928 4489712
20:15:09 8219 8192000000 10823824320 11251343360 1900602832 18.831 100 23 45 2 1912279360 4862608 6813920
20:15:27 8420 8192000000 10793506096 11224563712 1855895968 18.470 98 19 38 0 1867144064 5901952 5346144
20:15:47 9109 8192000000 10800997232 11241607168 1890114448 18.747 100 19 38 6 1900011328 5087520 4809360
20:16:08 9869 8192000000 10804843392 11244617728 1892704448 18.768 100 8 16 0 1900576736 5245936 2626352
20:16:29 7832 8192000000 10803602896 11235258368 1872571632 18.605 99 22 44 1 1883669952 5412320 5686000
20:16:43 13305 8192000000 10795372240 11232047104 1850814480 18.429 98 17 34 0 1862059296 5891296 5353520
20:17:09 46010 8192000000 10775966288 11197939712 1794139584 17.966 95 20 39 1 1804659808 4724352 5795872
20:18:01 16226 8192000000 10771388976 11200700416 1849215456 18.416 99 60 118 3 1871962704 5856256 16890992
20:18:27 7249 8192000000 10763637264 11195146240 1814814560 18.135 97 25 50 0 1831985776 10598560 6572656
20:18:41 9570 8192000000 10760936896 11188760576 1833325968 18.286 99 25 50 1 1845693296 5569600 6797728
20:18:57 4544 8192000000 10742058432 11157643264 1774781888 17.806 95 38 75 4 1792375968 7261280 10332800
20:19:08 4048 8192000000 10722372896 11140083712 1770613696 17.772 96 27 53 3 1784928960 6554448 7760816
20:19:24 4667 8192000000 10744374928 11171205120 1822907472 18.201 99 26 52 2 1837432736 6242400 8282864
20:19:35 7838 8192000000 10725568992 11151355904 1785112912 17.892 97 21 42 1 1797379088 5902208 6363968
20:19:49 4549 8192000000 10767242656 11182026752 1822582672 18.199 99 29 58 3 1836206704 5824480 7799552
20:20:00 7660 8192000000 10708678752 11132133376 1706140464 17.236 93 24 48 1 1718687984 5728624 6818896
20:20:15 4561 8192000000 10714192048 11129737216 1775924192 17.816 98 31 62 0 1791685024 5918384 9842448
20:20:26 8275 8192000000 10685133792 11095052288 1667281920 16.910 92 29 59 1 1680475280 4924128 8269232
20:20:42 8306 8192000000 10661469664 11078692864 1707736528 17.250 97 14 28 0 1716229280 5166448 3326304
20:20:56 5477 8192000000 10685565568 11106594816 1759830352 17.683 99 18 36 0 1770516672 5531712 5154608
20:21:08 9005 8192000000 10713132592 11130269696 1777476992 17.829 99 22 42 1 1789377376 5641632 6258752
20:21:24 6841 8192000000 10726547152 11132080128 1746834208 17.575 97 47 94 0 1766725152 5463152 14427792
20:21:37 13644 8192000000 10722555056 11137814528 1794965760 17.973 100 28 56 0 1808486720 4998304 8522656
20:22:03 67460 8192000000 10744581008 11168284672 1809181472 18.089 99 35 70 3 1825093184 5795200 10116512
20:23:20 9383 8192000000 10757518896 11187384320 1837832832 18.323 100 11 22 0 1845737744 5277312 2627600
20:23:39 6852 8192000000 10768013536 11192365056 1845236288 18.383 100 15 30 0 1855897952 5906560 4755104
20:23:52 10792 8192000000 10778150592 11201146880 1857296560 18.481 100 36 70 0 1874113632 6971248 9845824
20:24:11 8060 8192000000 10775674880 11206455296 1859006496 18.495 100 18 36 2 1869224912 5639280 4579136
20:24:25 5681 8192000000 10789129760 11208372224 1847286144 18.400 99 30 60 1 1862513792 6506288 8721360
20:24:40 14429 8192000000 10767314432 11203043328 1845937376 18.389 99 20 40 1 1857943360 6378544 5627440
20:25:01 7603 8192000000 10780642960 11209895936 1862041840 18.520 100 22 44 0 1875001360 6661936 6297584
20:25:23 11160 8192000000 10787094256 11214618624 1863726208 18.533 100 15 30 2 1873248528 5726016 3796304
20:25:42 10184 8192000000 10780095312 11216322560 1871129600 18.593 100 17 33 1 1881787888 5276256 5382032
20:25:58 7825 8192000000 10782015600 11222114304 1876036768 18.633 100 30 62 1 1894859808 9991024 8832016
20:26:12 14196 8192000000 10804805104 11229622272 1877344608 18.644 100 20 40 1 1889305728 6002208 5958912
20:26:34 5124 8192000000 10789716448 11225354240 1880880288 18.672 100 28 56 3 1895354928 6207152 8267488
20:26:46 7812 8192000000 10788905120 11227693056 1878166560 18.650 100 17 33 2 1887821712 4892928 4762224
20:27:07 53374 8192000000 10816972816 11254349824 1897450464 18.806 100 12 24 1 1905008656 4267488 3290704
20:28:19 59797 8192000000 10856856352 11288723456 1927236640 19.045 100 44 86 2 1949694880 11206720 11251520
20:29:27 4197 8192000000 10873047088 11293618176 1935015504 19.107 100 60 116 1 1959560144 8341824 16202816
20:29:39 20511 8192000000 10894972832 11314999296 1951708720 19.240 100 65 130 2 1981105488 10429664 18967104
20:30:05 10108 8192000000 10887635712 11318583296 1956873392 19.281 100 59 118 1 1983921200 11047584 16000224
20:30:27 18504 8192000000 10900130528 11320283136 1959408272 19.301 100 58 115 3 1986583376 11330640 15844464
20:30:54 12513 8192000000 10906014448 11335114752 1967964464 19.369 100 64 128 1 2000108640 13785152 18359024
20:31:22 28912 8192000000 10900141584 11339726848 1967924144 19.369 100 40 77 2 1992860304 13600848 11335312
20:32:06 18410 8192000000 10904908816 11344801792 1972737296 19.407 100 26 52 2 1993321792 12752688 7831808
20:32:31 13971 8192000000 10907858416 11342319616 1959016016 19.298 99 37 73 1 1981921648 12400848 10504784
20:32:53 25203 8192000000 10922814768 11357040640 1979274080 19.459 100 44 88 0 2006108368 14204320 12629968
20:33:27 13899 8192000000 10928919792 11364728832 1987283664 19.522 100 43 86 0 2016599008 16705904 12609440
20:33:54 20036 8192000000 10935678544 11374067712 1994421424 19.579 100 49 98 3 2028579392 19826832 14331136
20:34:21 24560 8192000000 10934979440 11376123904 1993564304 19.572 100 38 76 1 2026263264 20638736 12060224
20:34:54 10677 8192000000 10943185280 11381932032 1998579584 19.612 100 49 99 2 2033683488 20156048 14947856
20:35:13 12038 8192000000 10956650288 11390324736 2002986800 19.646 100 48 95 1 2039079056 22156896 13935360
20:35:38 13664 8192000000 10958658320 11395538944 2009151680 19.695 100 53 105 1 2048745328 24055456 15538192
20:36:03 13684 8192000000 10977050864 11409973248 2017264256 19.759 100 71 140 2 2066376592 27936256 21176080
20:36:25 3719 8192000000 10969904016 11400155136 2012378608 19.720 100 67 134 1 2061798656 28404864 21015184
20:36:38 7652 8192000000 10964411808 11399999488 1996348224 19.594 99 48 96 0 2039077776 27374112 15355440
20:36:55 4073 8192000000 10993941584 11414302720 2023334336 19.806 100 73 145 1 2072876864 28070560 21471968
20:37:06 4475 8192000000 10957018432 11380232192 1981999984 19.481 98 61 114 3 2025390880 26783488 16607408
20:37:19 14187 8192000000 10958158256 11387224064 1985533760 19.508 99 64 128 1 2036300096 31240352 19525984
20:37:44 12700 8192000000 10967794688 11400724480 1999850224 19.622 100 49 98 0 2048411600 32809552 15751824
20:38:08 7742 8192000000 10960048000 11390967808 1978443008 19.452 99 60 119 1 2031734048 34686720 18604320
20:38:22 17267 8192000000 10958691200 11398062080 1996601776 19.596 100 53 106 1 2049687248 36266672 16818800
20:38:53 6235 8192000000 10972035504 11408531456 2002779200 19.645 100 55 106 3 2058148336 38124512 17244624
20:39:08 19815 8192000000 10967137728 11405058048 1986494912 19.516 99 57 113 0 2042315728 38002080 17818736
20:39:49 15824 8192000000 10956617376 11397885952 1975936096 19.433 99 44 89 3 2030604864 40752576 13916192
20:40:23 17237 8192000000 10962378144 11405172736 1995034496 19.584 100 46 92 0 2056891104 47215104 14641504
20:40:51 8925 8192000000 10962523856 11394707456 1986191296 19.514 100 51 102 1 2046812160 44680176 15940688
20:41:11 4584 8192000000 10935415936 11363971072 1939825264 19.145 97 55 110 3 2010154496 53700400 16628832
20:41:23 1651 8192000000 10981467808 11409408000 2001024000 19.631 100 74 148 2 2071889280 46901616 23963664
20:41:32 2836 8192000000 10983443104 11407331328 2000176112 19.624 100 73 147 1 2068119952 45806736 22137104
20:41:41 1387 8192000000 10968218624 11389931520 1979691024 19.462 99 88 177 0 2051204176 45278688 26234464
20:41:50 1506 8192000000 10999973040 11417092096 2007170112 19.679 100 86 172 0 2080355120 47059552 26125456
20:41:58 1827 8192000000 10996858784 11418189824 2008385632 19.689 100 82 163 1 2081588896 48113216 25090048
20:42:06 6531 8192000000 10967452416 11404271616 1992633008 19.565 100 58 116 2 2057873280 46659376 18580896
20:42:21 3994 8192000000 10975716720 11410788352 1996590432 19.596 100 54 105 2 2060525360 47097104 16837824
20:42:33 9349 8192000000 10965489712 11399176192 1991112288 19.553 100 58 114 2 2053577360 44023200 18441872
20:42:51 7472 8192000000 10970750720 11402801152 1980192464 19.466 99 61 121 1 2045424400 46184912 19047024
20:43:09 2554 8192000000 10979438448 11396485120 1992843360 19.566 100 81 160 3 2064536304 47218224 24474720
20:43:19 1719 8192000000 10976742880 11397406720 1992414400 19.563 100 79 158 0 2063187696 46877344 23895952
20:43:28 2113 8192000000 10990876784 11408814080 1998969776 19.615 100 89 178 1 2072717472 46964528 26783168
20:43:37 1028 8192000000 10976390048 11387543552 1978185088 19.450 99 89 179 1 2056295744 50067376 28043280
20:43:46 1426 8192000000 10966426368 11374440448 1965795120 19.352 99 96 190 1 2043919616 50000768 28123728
20:43:54 2569 8192000000 10956809984 11370074112 1959668368 19.303 100 86 172 1 2037405296 51315072 26421856
20:44:04 2694 8192000000 10948426688 11363663872 1956217296 19.276 100 85 168 1 2033666112 51977248 25471568
20:44:14 4151 8192000000 10939012128 11351703552 1933910256 19.098 99 81 162 1 2012183536 52854336 25418944
20:44:26 4978 8192000000 10944325872 11362168832 1949286272 19.221 100 80 160 3 2024966368 51483472 24196624
20:44:38 2422 8192000000 10954773616 11368001536 1962911536 19.329 100 90 177 1 2040603072 50190944 27500592
20:44:49 6216 8192000000 10928679568 11351023616 1930704896 19.073 99 70 140 0 2000244768 48104544 21435328
20:45:06 1603 8192000000 10946624704 11365634048 1958509776 19.294 100 68 136 3 2026348064 46485024 21353264
20:45:15 1918 8192000000 10962483472 11371098112 1963846592 19.337 100 87 173 1 2037953440 47459696 26647152
20:45:25 2466 8192000000 10964485664 11382222848 1970928256 19.393 100 89 176 2 2049797344 51297104 27571984
20:45:35 2092 8192000000 10961570144 11382640640 1964140816 19.339 100 70 140 1 2039852704 54284576 21427312
20:45:44 2035 8192000000 10984924064 11394416640 1975663424 19.430 100 86 170 0 2058908752 56199008 27046320
20:45:53 1421 8192000000 10972935152 11386658816 1970013792 19.386 100 87 170 0 2055941392 59418032 26509568
20:46:02 1910 8192000000 10993868576 11401285632 1980095072 19.465 100 88 175 1 2065148288 58705472 26347744
20:46:11 1814 8192000000 10955828912 11362004992 1921670096 19.000 97 91 180 0 2009284976 59446208 28168672
20:46:19 2325 8192000000 10948751168 11358248960 1924897136 19.026 98 86 172 0 2012729472 60124992 27707344
20:46:30 2193 8192000000 10967622864 11371773952 1935185856 19.108 99 87 174 0 2022376320 60053872 27136592
20:46:40 8286 8192000000 10933124784 11353559040 1918680480 18.976 99 62 123 0 1998986384 60991664 19314240
20:46:55 2601 8192000000 10951904784 11365986304 1948260016 19.213 100 83 166 0 2033455184 59468752 25726416
20:47:08 4035 8192000000 10937018656 11358887936 1931965936 19.083 99 75 151 0 2012148144 55752688 24429520
20:47:19 2401 8192000000 10932846288 11341217792 1929709536 19.065 99 80 157 1 2006002576 51459280 24833760
20:47:28 4491 8192000000 10930298576 11343196160 1918783392 18.977 99 73 143 1 1989286992 48327216 22176384
20:47:40 1141 8192000000 10951797824 11353448448 1948906256 19.218 100 92 180 3 2026666752 50070160 27690336
20:47:49 3963 8192000000 10944455184 11358298112 1946519200 19.199 100 80 156 1 2023020928 52838656 23663072
20:48:00 3808 8192000000 10945550848 11371782144 1958721120 19.296 100 57 114 0 2030143696 53730000 17692576
20:48:15 9522 8192000000 10948810128 11374493696 1942386864 19.166 99 46 91 1 2012707040 55141600 15178576
20:48:41 9343 8192000000 10935126464 11376205824 1952169776 19.244 100 42 84 1 2026046176 59537152 14339248
20:49:11 4310 8192000000 10978736064 11395018752 1972274544 19.403 100 70 138 0 2054069360 59063392 22731424
20:49:22 5486 8192000000 10968573296 11390812160 1971303408 19.396 100 73 146 0 2052574608 57552368 23718832
20:49:42 19138 8192000000 10953962208 11390414848 1946722624 19.200 99 42 84 0 2021950736 60275744 14952368
20:50:13 18837 8192000000 10948919120 11395153920 1968679504 19.375 100 37 74 2 2038583600 56747856 13156240
20:50:51 11209 8192000000 10958254160 11401572352 1969885296 19.385 100 39 78 1 2038801680 55313824 13602560
20:51:08 17271 8192000000 10946452480 11391651840 1971310656 19.396 100 36 72 0 2037716496 53715488 12690352
20:51:34 12997 8192000000 10963611936 11404800000 1976076832 19.434 100 42 84 1 2047577712 56846384 14654496
20:51:55 18102 8192000000 10941868592 11393384448 1948278704 19.213 99 31 62 1 2020444672 60389440 11776528
20:52:46 23626 8192000000 10928144224 11385847808 1935636496 19.112 99 22 44 1 1996264928 52666576 7961856
20:53:17 41366 8192000000 10922486288 11388358656 1950132912 19.228 100 22 44 1 2014103328 55448688 8521728
20:54:46 26652 8192000000 10920821008 11385532416 1940339936 19.149 99 22 44 1 1993517552 45324544 7853072
20:55:20 12407 8192000000 10923249040 11381829632 1951911904 19.242 100 22 44 1 2001797952 42098256 7787792
20:55:44 16880 8192000000 10899488224 11393376256 1953831856 19.257 100 13 26 1 1989251488 30451568 4968064
20:56:07 39355 8192000000 10889365120 11338899456 1894149456 18.779 97 11 21 1 1914630608 16997200 3483952
20:58:03 49381 8192000000 10909909888 11354910720 1955627744 19.271 100 25 50 0 1977504320 13696016 8180560
20:59:12 37354 8192000000 10937927296 11368054784 1974229968 19.419 100 54 106 0 2004231840 14915904 15085968
20:59:57 1868 8192000000 10954995376 11381710848 1987931072 19.527 100 76 154 0 2028307296 17598992 22777232
21:00:05 46286 8192000000 10919371872 11370733568 1969223008 19.379 99 39 79 1 1991879136 11843920 10812208
21:00:57 29208 8192000000 10901812576 11365289984 1964760560 19.344 99 33 66 1 1985050496 10681888 9608048
21:01:38 20352 8192000000 10875615184 11350818816 1954197616 19.260 99 14 28 1 1969708480 11713872 3796992
21:02:04 71599 8192000000 10908252832 11368935424 1937942128 19.130 98 27 54 0 1955928320 10577168 7409024
21:03:47 24616 8192000000 10918553840 11380600832 1984544464 19.501 100 31 62 1 2008576624 15329504 8702656
21:04:23 65384 8192000000 10917092912 11386269696 1968599376 19.374 99 11 22 0 1987640896 15673328 3368192
21:06:09 52245 8192000000 10942690864 11411189760 2000179504 19.624 100 15 30 0 2025535600 20990400 4365696
21:07:08 58215 8192000000 10915542928 11370627072 1955608592 19.271 98 18 36 0 1976393136 15926128 4858416
21:08:15 81880 8192000000 10922427552 11389415424 1986438192 19.516 100 16 32 0 2011376176 19500224 5437760
21:10:10 89180 8192000000 10919672656 11396435968 1969718496 19.383 99 20 39 0 1992605344 17271696 5615152
21:12:34 83706 8192000000 10920010144 11399753728 1957616864 19.287 98 31 62 4 1990765808 23993520 9155424
21:14:07 90624 8192000000 10914475280 11370860544 1942213344 19.164 98 22 44 1 1964080560 14800576 7066640
21:15:44 28448 8192000000 10918334640 11377721344 1985308320 19.507 100 49 98 3 2010615792 11550784 13756688
21:16:25 80094 8192000000 10906108672 11381059584 1966855616 19.360 99 15 30 1 1983474688 12093840 4525232
21:17:56 69146 8192000000 10909516416 11386392576 1949246384 19.220 98 19 38 0 1971131104 16369040 5515680
21:19:19 81152 8192000000 10915587216 11385434112 1989725040 19.542 100 32 64 1 2011189632 12569040 8895552
21:20:53 23838 8192000000 10910871232 11371569152 1951011952 19.235 98 32 63 1 1969634560 10098864 8523744
21:21:29 37511 8192000000 10926212640 11394506752 1990222320 19.546 100 32 64 0 2015281664 15702544 9356800
21:22:21 81054 8192000000 10895837952 11371507712 1908173008 18.892 96 12 23 1 1925002400 13052464 3776928
21:23:49 38401 8192000000 10905759376 11367071744 1944967216 19.186 98 27 54 2 1959775808 7220320 7588272
21:24:34 70868 8192000000 10897253424 11373506560 1961656528 19.319 99 18 36 0 1977157968 10521392 4980048
21:26:23 46761 8192000000 10912143392 11377766400 1963162064 19.331 99 43 84 2 1990089296 14630816 12296416
21:27:17 70308 8192000000 10926602048 11387383808 1967596880 19.366 99 26 51 0 1988827104 14276000 6954224
21:28:39 71828 8192000000 10892445056 11361198080 1884126896 18.698 95 20 40 0 1902734416 13623440 4984080
21:30:08 74745 8192000000 10851375632 11308429312 1782697840 17.872 91 9 17 1 1797762864 12960704 2104320
21:31:29 203701 8192000000 10879826768 11347054592 1775884992 17.816 91 7 14 1 1794416368 17007328 1524048
21:35:15 120771 8192000000 10875113744 11332284416 1884611120 18.702 97 23 46 0 1906209456 14919232 6679104
21:37:33 56290 8192000000 10885141632 11334565888 1945722304 19.192 100 35 70 0 1964790672 8562144 10506224
21:38:36 43697 8192000000 10847810528 11298885632 1869348352 18.579 96 37 74 0 1889050736 8778160 10924224
21:39:28 22213 8192000000 10867654016 11317972992 1912493392 18.927 99 35 70 0 1932629568 9949632 10186544
21:40:45 50237 8192000000 10854945584 11323133952 1886682144 18.719 97 23 45 2 1900684048 7365616 6636288
21:41:42 69799 8192000000 10847333232 11319025664 1880266432 18.667 97 28 55 0 1898030688 10598192 7166064
21:42:58 36930 8192000000 10849223024 11327713280 1925701744 19.032 100 6 12 0 1943411456 16168928 1540784
21:43:41 3808 8192000000 10844642048 11322077184 1925227504 19.029 100 8 16 0 1943037680 15414688 2395488
21:43:53 44682 8192000000 10835697056 11310190592 1890817600 18.752 98 9 18 0 1903867216 10647392 2402224
21:44:46 65134 8192000000 10865975952 11330347008 1916649136 18.960 99 21 42 0 1932725616 9533488 6542992
21:45:59 73868 8192000000 10861274176 11340406784 1924602432 19.024 99 16 32 0 1946544016 17327008 4614576
21:47:21 90613 8192000000 10861589888 11326373888 1847893696 18.405 95 12 24 0 1862991424 11842032 3255696
21:49:00 39176 8192000000 10853352928 11321520128 1901022704 18.835 98 29 58 0 1923877136 15182016 7672416
21:50:28 51775 8192000000 10884944528 11337965568 1901065216 18.835 98 13 26 0 1918361776 13926288 3370272
21:51:29 72056 8192000000 10869914448 11341197312 1928166000 19.052 99 24 48 1 1947943664 12866816 6910848
21:52:53 66526 8192000000 10874381232 11354595328 1953840864 19.257 100 18 36 0 1973322592 14114352 5367376
21:54:25 64101 8192000000 10868656864 11328483328 1873639152 18.614 96 24 48 0 1887403744 7896704 5867888
21:55:35 21863 8192000000 10886114000 11342237696 1949075648 19.219 100 51 102 1 1972534976 9565712 13893616
21:56:03 48465 8192000000 10893329776 11349491712 1920711360 18.993 98 36 72 2 1942072496 11340960 10020176
21:57:01 32025 8192000000 10897910784 11359326208 1953736592 19.256 100 19 38 1 1974126096 14908992 5480512
21:57:40 113519 8192000000 10906291120 11369746432 1919858352 18.986 98 13 26 0 1937673824 14489776 3325696
21:59:46 45666 8192000000 10903293472 11372429312 1954530576 19.263 99 14 28 0 1975420656 17022832 3867248
22:01:04 176622 8192000000 10893230528 11367563264 1914798256 18.945 97 15 30 1 1934449680 15608576 4042848
22:04:08 76579 8192000000 10882487056 11366936576 1950815536 19.233 99 12 24 1 1966622048 12493456 3313056
22:05:37 60152 8192000000 10882987856 11372318720 1929632960 19.064 98 5 10 0 1944403072 13249632 1520480
22:07:11 37537 8192000000 10881246048 11355848704 1927929776 19.050 98 21 41 1 1944295200 10204480 6160944
22:07:55 46401 8192000000 10913145376 11369291776 1962731168 19.328 100 16 32 0 1978293952 11281152 4281632
22:08:55 92696 8192000000 10875851584 11354963968 1910450784 18.910 97 14 28 1 1924065696 9740688 3874224
22:10:34 44230 8192000000 10893403376 11358318592 1922901024 19.010 98 17 34 1 1939546864 12361712 4284128
22:11:25 95918 8192000000 10871218352 11347271680 1865152832 18.545 95 12 23 1 1875168240 7531904 2483504
22:13:09 38224 8192000000 10903875040 11363082240 1953946192 19.258 99 37 73 1 1973669232 9737296 9985744
22:13:53 29752 8192000000 10907318752 11359125504 1933268512 19.093 98 42 84 0 1958206032 13171248 11766272
22:14:42 77721 8192000000 10891957232 11375652864 1940322320 19.149 99 7 15 0 1964247360 22097904 1827136
22:16:10 155398 8192000000 10891154016 11359969280 1871133296 18.593 95 7 14 1 1895573920 22728096 1712528
22:18:52 26831 8192000000 10884092448 11339522048 1916008496 18.955 98 35 70 1 1934560272 8544304 10007472
22:19:25 94652 8192000000 10899140800 11373084672 1902905232 18.850 97 18 36 0 1929488352 22090192 4492928
22:21:08 162173 8192000000 10866753808 11334545408 1859421792 18.499 95 24 48 0 1877147392 11089296 6636304
22:23:57 25080 8192000000 10867164368 11329441792 1925196080 19.028 99 29 57 0 1941091120 8379184 7515856
22:24:29 36998 8192000000 10855872864 11331600384 1923631792 19.016 99 23 46 1 1939372864 9622560 6118512
22:25:36 108201 8192000000 10865708032 11359621120 1949753568 19.225 100 7 14 0 1961201424 9248224 2199632

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 04-04-2021 22:29:15 to 04-04-2021 22:29:46.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 129 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 04-04-2021 22:29:47 to 04-04-2021 22:29:49.

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          237990
MON$OLDEST_ACTIVE               237991
MON$OLDEST_SNAPSHOT             237991
MON$NEXT_TRANSACTION            237991
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                       2036320
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.33438 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33438 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33438 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33438 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 ---
:52: 
:53: mscs-test-161.budzdorov.ru    Sun Apr  4 22:27:36 2021
:54:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:55: 
:56: 
:57: mscs-test-161.budzdorov.ru    Sun Apr  4 22:27:38 2021
:58:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:59: 
--- end of diff output ---

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

04.04.21 22:29:50. 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-04-04 22:29:52 No severe PSQL-related problems occured
04.04.21 22:29:54. End of report.