Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 09.01.2021 01:27
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 17129216 kB
MemAvailable 31343588 kB
Buffers 0 kB
Cached 14519024 kB
SwapCached 4864 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-01-09 01:27:10
DTS_END                         2021-01-09 01:27:10.3260
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_RECALC_IDX_STAT(24:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/51456
TRN_ID                          239940
ATT_ID                          639
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: 9564.33 22684 1147719
customer order: creation 170.25 343 20430
customer order: refuse 14.63 321 1756
order to supplier: creation 45.09 1429 5411
order to supplier: removal 3.58 99172 429
invoice (draft): creation 45.98 3377 5518
invoice (draft): removal 57.08 819 6849
invoice accept: apply 40.23 16581 4827
invoice accept: cancel 51.73 723 6208
customer reserve: creation 3790.68 160 454882
customer reserve: removal 5042.82 54 605138
realization accept: apply 83.80 194 10056
realization accept: cancel 90.18 101 10821
payment from customer: creation 60.34 131 7241
payment from customer: removal 5.10 86 612
payment to supplier: creation 47.39 137 5687
payment to supplier: removal 3.44 100 413
service: total inventory turnovers 4.67 1141 560
service: total monetary turnovers 6.39 103 767
service: aggregate perf. data 0.92 17265 110
service: refresh index statistics 0.03 311447 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 09-01-2021 01:27:48 to 09-01-2021 01:27:50.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4804
TEST_TIME 2 4515
TEST_TIME 3 4446
TEST_TIME 4 4446
TEST_TIME 5 4267
TEST_TIME 6 4575
TEST_TIME 7 4412
TEST_TIME 8 4979
TEST_TIME 9 4900
TEST_TIME 10 5173
TEST_TIME 11 5235
TEST_TIME 12 5785
TEST_TIME 13 6144
TEST_TIME 14 6287
TEST_TIME 15 6889
TEST_TIME 16 7425
TEST_TIME 17 7875
TEST_TIME 18 7781
TEST_TIME 19 7824
TEST_TIME 20 8535
TEST_TIME 21 8580
TEST_TIME 22 8643
TEST_TIME 23 9557
TEST_TIME 24 9659
TEST_TIME 25 10105
TEST_TIME 26 10368
TEST_TIME 27 10884
TEST_TIME 28 11145
TEST_TIME 29 11197
TEST_TIME 30 10899
TEST_TIME 31 10748
TEST_TIME 32 11007
TEST_TIME 33 11270
TEST_TIME 34 11114
TEST_TIME 35 10842
TEST_TIME 36 10571
TEST_TIME 37 10388
TEST_TIME 38 10434
TEST_TIME 39 10276
TEST_TIME 40 10304
TEST_TIME 41 10326
TEST_TIME 42 10263
TEST_TIME 43 10206
TEST_TIME 44 10140
TEST_TIME 45 10021
TEST_TIME 46 9932
TEST_TIME 47 9777
TEST_TIME 48 9837
TEST_TIME 49 9821
TEST_TIME 50 9801
TEST_TIME 51 9700
TEST_TIME 52 9792
TEST_TIME 53 9763
TEST_TIME 54 9743
TEST_TIME 55 9851
TEST_TIME 56 9804
TEST_TIME 57 9793
TEST_TIME 58 9958
TEST_TIME 59 9878
TEST_TIME 60 10010
TEST_TIME 61 10007
TEST_TIME 62 10002
TEST_TIME 63 10078
TEST_TIME 64 10300
TEST_TIME 65 10200
TEST_TIME 66 10054
TEST_TIME 67 9979
TEST_TIME 68 9929
TEST_TIME 69 9857
TEST_TIME 70 9842
TEST_TIME 71 9761
TEST_TIME 72 9725
TEST_TIME 73 9648
TEST_TIME 74 9661
TEST_TIME 75 9576
TEST_TIME 76 9628
TEST_TIME 77 9610
TEST_TIME 78 9565
TEST_TIME 79 9617
TEST_TIME 80 9555
TEST_TIME 81 9506
TEST_TIME 82 9485
TEST_TIME 83 9521
TEST_TIME 84 9507
TEST_TIME 85 9502
TEST_TIME 86 9482
TEST_TIME 87 9532
TEST_TIME 88 9552
TEST_TIME 89 9569
TEST_TIME 90 9619
TEST_TIME 91 9603
TEST_TIME 92 9674
TEST_TIME 93 9649
TEST_TIME 94 9778
TEST_TIME 95 9717
TEST_TIME 96 9733
TEST_TIME 97 9709
TEST_TIME 98 9741
TEST_TIME 99 9680
TEST_TIME 100 9630
TEST_TIME 101 9601
TEST_TIME 102 9585
TEST_TIME 103 9579
TEST_TIME 104 9549
TEST_TIME 105 9535
TEST_TIME 106 9517
TEST_TIME 107 9500
TEST_TIME 108 9502
TEST_TIME 109 9478
TEST_TIME 110 9482
TEST_TIME 111 9506
TEST_TIME 112 9504
TEST_TIME 113 9532
TEST_TIME 114 9563
TEST_TIME 115 9565
TEST_TIME 116 9600
TEST_TIME 117 9613
TEST_TIME 118 9632
TEST_TIME 119 9633
TEST_TIME 120 9569

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 09-01-2021 01:27:52 to 09-01-2021 01:27:55.

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 1569308 1569308 0 0.00 0 21493 6 0 0
doc_list_biud 1569308 1569308 0 0.00 0 47419 27 0 0
sp_add_invoice_to_stock 5014 4827 187 3.72 40 182463 16582 0 187
sp_cancel_adding_invoice 6208 6208 0 0.00 5 49012 723 0 0
sp_cancel_client_order 1756 1756 0 0.00 4 8143 322 0 0
sp_cancel_customer_reserve 605138 605138 0 0.00 1 47421 54 0 0
sp_cancel_pay_from_customer 612 612 0 0.00 2 3916 86 0 0
sp_cancel_pay_to_supplier 413 413 0 0.00 2 4838 100 0 0
sp_cancel_supplier_invoice 6859 6849 10 0.14 2 17594 819 0 10
sp_cancel_supplier_order 429 429 0 0.00 7 1105509 99173 0 0
sp_cancel_write_off 10821 10821 0 0.00 1 14486 102 0 0
sp_client_order 20430 20430 0 0.00 3 45127 344 0 0
sp_customer_reserve 454882 454882 0 0.00 0 96246 160 0 0
sp_fill_shopping_cart 31354 31354 0 0.00 1 11041 41 0 0
sp_fill_shopping_cart_clo_res 454875 454875 0 0.00 0 15533 13 0 0
sp_get_clo_for_invoice 4820 4820 0 0.00 0 15070 290 0 0
sp_kill_cost_storno 18054 18054 0 0.00 0 12896 56 0 0
sp_kill_qstorno_ret_qs2qd 1228375 1228375 0 0.00 0 47416 30 0 0
sp_kill_qty_storno 646077 646077 0 0.00 0 47419 64 0 0
sp_lock_selected_doc 20646 20646 0 0.00 0 8426 5 0 0
sp_make_cost_storno 27804 27804 0 0.00 0 21486 59 0 0
sp_multiply_rows_for_pdistr 27804 27804 0 0.00 0 8798 34 0 0
sp_multiply_rows_for_qdistr 20430 20430 0 0.00 0 45116 156 0 0
sp_pay_from_customer 7241 7241 0 0.00 4 15885 131 0 0
sp_pay_to_supplier 5687 5687 0 0.00 5 21508 138 0 0
sp_payment_common 12928 12928 0 0.00 1 14003 37 0 0
sp_qd_handle_on_cancel_clo 1756 1756 0 0.00 0 8137 290 0 0
sp_qd_handle_on_invoice_upd_sts 11028 11028 0 0.00 0 14752 317 0 0
sp_qd_handle_on_reserve_upd_sts 10056 10056 0 0.00 0 18845 57 0 0
sp_reserve_write_off 10056 10056 0 0.00 6 23233 195 0 0
sp_supplier_invoice 5518 5518 0 0.00 5 100462 3378 0 0
sp_supplier_order 5411 5411 0 0.00 5 34048 1430 0 0
srv_aggregate_perf_data 110 110 0 0.00 2785 190948 17265 0 0
srv_fill_mon_cache_memory 156 156 0 0.00 1031 154516 34397 0 0
srv_find_qd_qs_mism 1100720 1100720 0 0.00 0 13222 4 0 0
srv_make_invnt_saldo 560 560 0 0.00 47 77229 1142 0 0
srv_make_money_saldo 767 767 0 0.00 0 62711 103 0 0
srv_recalc_idx_stat 4 4 0 0.00 184415 443915 311448 0 0
t$perf-abend:sp_add_invoice_to_stock 187 187 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4827 4827 0 0.00 0 13973 176 0 0
t$perf-norm:sp_cancel_adding_invoice 411 411 0 0.00 0 6584 128 0 0
t$perf-norm:sp_cancel_client_order 1756 1756 0 0.00 0 5291 17 0 0
t$perf-norm:sp_cancel_customer_reserve 704 704 0 0.00 0 4894 15 0 0
t$perf-norm:sp_cancel_pay_from_customer 612 612 0 0.00 0 1854 8 0 0
t$perf-norm:sp_cancel_pay_to_supplier 413 413 0 0.00 0 1139 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 408 408 0 0.00 0 1466 13 0 0
t$perf-norm:sp_cancel_supplier_order 429 429 0 0.00 0 20365 1763 0 0
t$perf-norm:sp_cancel_write_off 1038 1038 0 0.00 0 1889 8 0 0
t$perf-norm:sp_client_order 20430 20430 0 0.00 0 22428 24 0 0
t$perf-norm:sp_customer_reserve 1025 1025 0 0.00 0 1773 7 0 0
t$perf-norm:sp_pay_from_customer 7241 7241 0 0.00 0 11450 17 0 0
t$perf-norm:sp_pay_to_supplier 5687 5687 0 0.00 0 7959 9 0 0
t$perf-norm:sp_reserve_write_off 10056 10056 0 0.00 0 17820 16 0 0
t$perf-norm:sp_supplier_invoice 5518 5518 0 0.00 0 10060 26 0 0
t$perf-norm:sp_supplier_order 5411 5411 0 0.00 0 11440 21 0 0
t$perf-norm:srv_aggregate_perf_data 110 110 0 0.00 0 287 9 0 0
t$perf-norm:srv_fill_mon_cache_memory 156 156 0 0.00 0 794 13 0 0
t$perf-norm:srv_make_invnt_saldo 560 560 0 0.00 0 1346 25 0 0
t$perf-norm:srv_make_money_saldo 767 767 0 0.00 0 1117 19 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 151 40 0 0
v_add_invoice_to_stock 10011 9637 374 3.73 0 6464 21 0 374
v_all_customers 38192 38192 0 0.00 0 15 1 0 0
v_all_suppliers 30308 30308 0 0.00 0 15 1 0 0
v_all_wares 40860 40860 0 0.00 0 22 1 0 0
v_cancel_adding_invoice 822 822 0 0.00 0 885 7 0 0
v_cancel_client_order 3512 3512 0 0.00 0 1428 5 0 0
v_cancel_customer_prepayment 1224 1224 0 0.00 0 1743 8 0 0
v_cancel_customer_reserve 1408 1408 0 0.00 0 3359 6 0 0
v_cancel_payment_to_supplier 826 826 0 0.00 0 1846 6 0 0
v_cancel_supplier_invoice 836 816 20 2.39 0 1048 16 0 20
v_cancel_supplier_order 858 858 0 0.00 0 3037 8 0 0
v_cancel_write_off 2076 2076 0 0.00 0 325 11 0 0
v_max_id_clo_ord 5411 5411 0 0.00 0 412 1 0 0
v_max_id_clo_res 1025 1025 0 0.00 0 4404 23 0 0
v_max_id_ord_sup 5513 5513 0 0.00 0 5827 4 0 0
v_max_non_paid_invoice 1457 1457 0 0.00 0 1326 4 0 0
v_max_non_paid_realizn 3550 3550 0 0.00 0 6194 6 0 0
v_min_id_clo_ord 5411 5411 0 0.00 0 8559 13 0 0
v_min_id_clo_res 1025 1025 0 0.00 0 2929 4 0 0
v_min_id_ord_sup 5513 5513 0 0.00 0 7767 10 0 0
v_min_non_paid_invoice 5687 5687 0 0.00 0 12758 20 0 0
v_min_non_paid_realizn 7241 7241 0 0.00 0 13141 27 0 0
v_our_firm 10050 10050 0 0.00 0 15 1 0 0
v_reserve_write_off 20112 20112 0 0.00 0 3733 6 0 0
x_lock_depdocs_on_canc_invoice 12649 12649 0 0.00 0 12674 112 0 0
x_lock_depdocs_on_canc_sup_ord 429 429 0 0.00 0 19755 415 0 0
x_make_qstorno_1000_1200 5411 5411 0 0.00 1 34039 1337 0 0
x_make_qstorno_1200_2000 5518 5518 0 0.00 2 100342 3239 0 0
x_make_qstorno_2100_3300 454882 454882 0 0.00 0 96244 145 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 09-01-2021 01:27:56 to 09-01-2021 01:28:00.

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
22:57:13 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:20 12757 8192000000 10231203888 10531905536 936762816 10.261 73 61 122 0 959310512 2544608 20003088
22:57:42 24588 8192000000 10318508112 10633715712 1369303216 14.321 100 87 175 0 1403240256 4819952 29117088
22:58:16 17497 8192000000 10362907792 10681470976 1421539120 14.786 100 89 178 1 1457452320 6101392 29811808
22:58:43 26675 8192000000 10393783840 10719383552 1440878816 14.957 100 88 176 0 1477383280 7456576 29047888
22:59:22 17415 8192000000 10414390272 10742546432 1460825680 15.133 100 87 174 0 1501449488 12406240 28217568
22:59:51 13620 8192000000 10420176176 10747895808 1477140400 15.276 100 87 175 0 1513943744 8504752 28298592
23:00:28 24618 8192000000 10460794416 10798948352 1507240816 15.539 100 86 172 0 1543295216 8943776 27110624
23:01:08 8305 8192000000 10490356416 10831745024 1544384528 15.861 100 85 170 0 1581475152 9860352 27230272
23:01:29 15028 8192000000 10508691328 10854301696 1564905520 16.038 100 84 168 0 1601309264 10320336 26083408
23:01:59 11219 8192000000 10520897936 10873524224 1580285008 16.171 100 83 163 1 1616062704 10358416 25419280
23:02:17 9582 8192000000 10544140544 10897584128 1599093936 16.332 100 77 154 1 1633133328 10520560 23518832
23:02:45 12584 8192000000 10574501072 10935386112 1630524480 16.599 100 76 152 1 1664374880 10833392 23017008
23:03:07 14600 8192000000 10602474816 10966237184 1662590640 16.871 100 82 164 0 1698423392 11470128 24362624
23:03:35 8788 8192000000 10628650480 10999173120 1689118240 17.094 100 73 146 1 1721677728 11184496 21374992
23:03:52 8620 8192000000 10656380832 11027550208 1713953984 17.302 100 84 167 2 1750455664 12168688 24332992
23:04:09 9074 8192000000 10668749696 11039105024 1727070080 17.411 100 83 167 2 1763894224 12568544 24255600
23:04:28 6066 8192000000 10669680912 11044417536 1734306400 17.471 100 83 167 0 1770974208 12904064 23763744
23:04:42 5295 8192000000 10688367088 11063336960 1746115696 17.569 100 85 170 0 1784026864 13572928 24338240
23:04:54 6287 8192000000 10689804800 11069911040 1757937120 17.667 100 80 160 1 1793643968 13302048 22404800
23:05:09 3781 8192000000 10704033744 11084464128 1768630352 17.756 100 85 169 2 1805390128 12934352 23825424
23:05:21 3597 8192000000 10714430608 11089485824 1772480064 17.787 100 84 168 0 1808858432 13238128 23140240
23:05:32 3960 8192000000 10722578928 11104948224 1782250848 17.868 100 84 164 1 1819194736 13305408 23638480
23:05:43 3480 8192000000 10730855504 11109109760 1788192288 17.917 100 92 184 1 1827281696 13957232 25132176
23:05:53 2499 8192000000 10732690128 11114295296 1797148096 17.991 100 87 173 1 1835322512 13374928 24799488
23:06:02 3276 8192000000 10744366256 11126251520 1799298384 18.008 100 84 167 0 1837011392 14104368 23608640
23:06:14 2175 8192000000 10743094848 11126652928 1801984096 18.030 100 77 154 0 1836007616 12613536 21409984
23:06:22 7871 8192000000 10738115792 11132846080 1812299216 18.115 100 87 172 3 1849565072 13036928 24228928
23:06:38 4285 8192000000 10757981424 11144994816 1817228768 18.155 100 81 163 2 1853153616 13450272 22474576
23:06:50 1896 8192000000 10783215360 11168096256 1838427936 18.328 100 87 174 0 1877632960 14411744 24793280
23:06:58 1766 8192000000 10785906160 11171487744 1841590176 18.354 100 84 168 1 1876663776 11751504 23322096
23:07:07 2069 8192000000 10788258080 11173249024 1845101424 18.382 100 84 169 1 1881777664 12198912 24477328
23:07:15 1540 8192000000 10795508272 11183947776 1848656736 18.411 100 87 176 3 1886593088 13017856 24918496
23:07:23 1905 8192000000 10794922000 11181256704 1855975936 18.471 100 89 178 1 1895899216 13321888 26601392
23:07:31 1760 8192000000 10790344400 11182399488 1857382048 18.482 100 86 172 0 1894247936 12656272 24209616
23:07:39 1751 8192000000 10795292736 11187978240 1856611280 18.476 100 87 173 0 1894022896 13339008 24072608
23:07:47 1618 8192000000 10797734512 11191742464 1862973712 18.527 100 84 169 0 1900382944 14089616 23319616
23:07:57 18819 8192000000 10787914896 11186528256 1856952592 18.479 100 63 122 2 1885548720 10699280 17896848
23:08:22 2548 8192000000 10788277696 11194933248 1856874944 18.478 100 54 109 0 1882487248 10688000 14924304
23:08:32 4349 8192000000 10781335296 11192770560 1856932960 18.478 100 46 91 1 1879772208 10307632 12531616
23:08:43 3827 8192000000 10782135984 11197718528 1864423248 18.539 100 51 102 1 1888235760 8942880 14869632
23:08:56 5057 8192000000 10786664624 11201921024 1866259536 18.554 100 41 82 2 1886705072 9175168 11270368
23:09:09 5054 8192000000 10786741760 11205447680 1867267728 18.562 100 42 85 1 1888165696 9697920 11200048
23:09:21 3054 8192000000 10788225376 11205197824 1871125568 18.593 100 43 85 3 1892172976 8916624 12130784
23:09:30 6558 8192000000 10780198576 11203743744 1870769840 18.591 100 25 50 0 1885252848 7323392 7159616
23:09:46 4734 8192000000 10786563872 11208986624 1873660272 18.614 100 32 65 0 1889986480 7388112 8938096
23:10:01 4148 8192000000 10801871200 11214667776 1877840352 18.648 100 39 78 0 1896149472 7624736 10684384
23:10:12 5464 8192000000 10775414496 11211210752 1877125168 18.642 100 31 62 1 1894260960 8326560 8809232
23:10:24 6677 8192000000 10783896208 11212095488 1876507584 18.637 100 25 50 0 1889450992 5959120 6984288
23:10:39 11111 8192000000 10784869120 11212693504 1874824288 18.623 100 15 30 0 1885476176 6322672 4329216
23:10:56 16248 8192000000 10784101792 11213766656 1880272928 18.667 100 24 48 0 1893707792 6409536 7025328
23:11:25 61405 8192000000 10799567056 11229564928 1883807456 18.696 100 30 61 0 1897579072 5476496 8295120
23:12:40 6816 8192000000 10809544912 11231277056 1885390960 18.709 100 40 79 1 1904386560 8178704 10816896
23:12:55 4137 8192000000 10806139552 11233656832 1886947152 18.721 100 41 82 2 1906042528 7113984 11981392
23:13:07 4467 8192000000 10804660672 11233472512 1887748656 18.728 100 37 74 1 1906224144 8495632 9979856
23:13:17 8760 8192000000 10806088128 11233415168 1887066192 18.722 100 26 52 1 1900244384 5467536 7710656
23:13:33 8555 8192000000 10795865776 11231694848 1886230096 18.715 100 21 42 0 1897739216 5652128 5856992
23:13:51 2925 8192000000 10808953872 11233009664 1889698480 18.743 100 42 82 2 1908703360 5976160 13028720
23:14:00 9275 8192000000 10808615744 11239034880 1886290240 18.716 100 19 36 5 1901785984 10322960 5172784
23:14:18 9459 8192000000 10804055744 11237933056 1893382528 18.773 100 19 38 1 1904953056 6415760 5154768
23:14:35 9731 8192000000 10807141168 11243106304 1896038880 18.794 100 15 30 0 1905638000 5763808 3835312
23:14:55 10391 8192000000 10807971312 11247120384 1895707504 18.792 100 22 44 1 1908263824 6542416 6013904
23:15:15 9123 8192000000 10790722832 11226054656 1883094352 18.690 99 28 56 3 1900834112 10148464 7591296
23:15:31 8791 8192000000 10813606416 11244908544 1876864128 18.640 99 21 42 1 1889069536 5839664 6365744
23:15:46 58765 8192000000 10828748496 11254915072 1907009168 18.883 100 41 82 1 1924435792 5235488 12191136
23:16:52 12524 8192000000 10819189120 11255992320 1902594992 18.847 100 19 38 2 1913550992 6184144 4771856
23:17:10 9137 8192000000 10810632736 11235581952 1874924896 18.624 99 29 59 1 1889637760 6570976 8141888
23:17:28 3448 8192000000 10813945392 11228995584 1873049264 18.609 99 39 80 1 1889510880 5204656 11256960
23:17:38 6937 8192000000 10800402240 11226365952 1866456592 18.556 99 32 64 0 1883541728 8211936 8873200
23:17:51 6706 8192000000 10789542176 11216527360 1871889872 18.600 100 24 49 0 1885778832 6586624 7302336
23:18:04 7355 8192000000 10781587616 11202535424 1809424832 18.091 96 32 63 1 1828853392 10233696 9194864
23:18:19 4702 8192000000 10770864288 11195072512 1855878272 18.470 100 28 56 1 1874542880 10684864 7979744
23:18:30 7963 8192000000 10763704512 11188772864 1776813488 17.823 95 31 62 2 1791078256 5655376 8609392
23:18:45 7063 8192000000 10732722880 11151949824 1727292640 17.413 93 23 43 1 1738569136 4825744 6450752
23:19:00 7488 8192000000 10702605824 11106283520 1719048032 17.344 96 12 24 0 1727746880 5189584 3509264
23:19:16 5349 8192000000 10685480128 11094736896 1698180336 17.170 95 15 30 2 1707820576 5388656 4251584
23:19:28 11652 8192000000 10690470496 11107028992 1705315904 17.230 95 17 34 1 1715142176 5111472 4714800
23:19:49 7361 8192000000 10691816656 11109568512 1721276512 17.363 96 29 58 2 1736145104 6243584 8625008
23:20:02 5874 8192000000 10687593856 11098181632 1753526768 17.631 98 25 48 5 1766143248 5501296 7115184
23:20:16 64184 8192000000 10680958208 11102375936 1711135712 17.278 95 28 56 0 1724651008 4814016 8701280
23:21:27 9476 8192000000 10706615520 11121664000 1727010608 17.411 95 26 52 1 1739962784 5886448 7065728
23:21:44 12274 8192000000 10711296880 11134156800 1750321488 17.604 97 20 40 2 1761330544 5752048 5257008
23:22:04 5990 8192000000 10734311344 11147620352 1798612640 18.003 99 23 46 1 1811851184 5940512 7298032
23:22:18 7248 8192000000 10743228208 11162189824 1826926512 18.234 100 33 66 1 1844322800 8158144 9238144
23:22:31 8231 8192000000 10753706256 11171168256 1836905552 18.316 100 31 62 3 1852210448 6002784 9302112
23:22:46 6616 8192000000 10748321568 11177414656 1840963152 18.349 100 25 50 1 1855359440 6285456 8110832
23:23:02 8986 8192000000 10754173680 11175661568 1840623504 18.346 100 30 60 3 1853939152 4614544 8701104
23:23:18 9946 8192000000 10744742944 11170013184 1820280864 18.180 99 14 28 0 1829751840 5355904 4115072
23:23:38 14812 8192000000 10768307040 11188383744 1844351344 18.376 100 25 50 3 1857122064 5945024 6825696
23:24:01 12463 8192000000 10775012512 11196248064 1852525264 18.443 100 13 24 1 1861144464 4921680 3697520
23:24:21 12994 8192000000 10766217712 11200368640 1858275920 18.489 100 16 30 1 1867968416 5316880 4375616
23:24:42 14742 8192000000 10777088752 11208753152 1865033856 18.544 100 16 32 1 1875322224 5492960 4795408
23:25:03 71756 8192000000 10780971552 11215286272 1871203424 18.594 100 28 56 0 1885379552 5458608 8717520
23:26:23 12406 8192000000 10798472032 11224420352 1878380016 18.652 100 39 78 0 1897259776 8091872 10787888
23:26:45 7551 8192000000 10788860576 11220914176 1878026464 18.649 100 35 70 3 1895756368 6408160 11321744
23:27:02 57387 8192000000 10821111232 11250429952 1890408320 18.749 100 21 42 2 1905469552 9266592 5794640
23:28:10 6176 8192000000 10849835088 11268866048 1920190864 18.988 100 52 104 3 1941394464 7079552 14124048
23:28:24 2906 8192000000 10866622800 11281096704 1929472864 19.063 100 64 126 4 1956513072 8684544 18355664
23:28:36 30711 8192000000 10864814080 11286192128 1936437968 19.118 100 56 112 2 1961251632 9063392 15750272
23:29:18 18568 8192000000 10870572208 11296149504 1938116416 19.132 100 33 66 0 1957709296 10460992 9131888
23:29:46 36987 8192000000 10867595888 11296202752 1926547568 19.039 99 39 77 2 1948612096 11005888 11058640
23:30:31 18468 8192000000 10880508144 11309256704 1953060176 19.251 100 50 101 1 1980217712 12386848 14770688
23:30:57 15493 8192000000 10887659696 11315920896 1956556432 19.279 100 43 86 2 1982772208 13167472 13048304
23:31:43 22120 8192000000 10899018448 11334316032 1964506496 19.342 100 33 66 1 1989801456 15184272 10110688
23:32:13 76364 8192000000 10908498128 11351572480 1976925920 19.440 100 34 68 1 2005508224 17997136 10585168
23:33:40 25885 8192000000 10917699808 11361386496 1980548352 19.469 100 24 48 3 2009148080 20970224 7629504
23:34:14 16666 8192000000 10930764704 11367272448 1992484256 19.563 100 38 76 1 2026436848 22716464 11236128
23:34:38 13374 8192000000 10951535952 11385303040 1998127984 19.608 100 41 82 1 2037931440 26851536 12951920
23:35:02 6156 8192000000 10962249264 11387752448 2000595952 19.627 100 47 94 1 2042732544 27941984 14194608
23:35:15 25006 8192000000 10944154672 11387715584 1984153248 19.498 99 50 99 0 2027028048 27888224 14986576
23:35:53 8308 8192000000 10962322208 11396702208 2004389216 19.657 100 47 94 1 2050489552 31206224 14894112
23:36:11 2252 8192000000 10958277808 11393687552 2006265136 19.672 100 44 88 1 2048863168 28304624 14293408
23:36:21 6865 8192000000 10963061024 11398045696 2009917328 19.701 100 56 112 0 2056909680 29767024 17225328
23:36:38 7573 8192000000 10979233184 11414945792 2017098096 19.757 100 52 104 0 2072220112 38864560 16257456
23:36:55 9441 8192000000 10972551808 11413331968 2017361024 19.759 100 50 99 0 2066412032 33864784 15186224
23:37:18 4470 8192000000 10991429088 11424866304 2022804208 19.802 100 62 124 1 2079646096 39314816 17527072
23:37:34 11644 8192000000 10977956960 11410399232 2001807376 19.637 99 54 108 1 2052805824 34393392 16605056
23:37:53 4442 8192000000 10968006896 11399782400 2007284832 19.680 100 54 108 0 2058188400 34128880 16774688
23:38:07 5398 8192000000 10980570816 11417325568 2019748272 19.778 100 56 112 2 2071649744 34519584 17381888
23:38:21 3293 8192000000 10983484912 11413848064 2017305360 19.759 100 67 134 1 2073112080 35532000 20274720
23:38:33 6977 8192000000 10988845744 11411959808 2004598048 19.659 99 74 146 3 2064809712 37534784 22676880
23:38:48 5907 8192000000 10978319824 11403767808 2005042112 19.662 99 69 138 0 2065858720 39311232 21505376
23:39:00 3214 8192000000 10989842464 11411845120 2012710192 19.723 100 81 162 1 2076094208 38992736 24391280
23:39:10 3109 8192000000 10979569008 11401551872 1994013872 19.575 99 84 167 2 2059603664 39934048 25655744
23:39:21 3312 8192000000 10972496912 11396415488 2005606816 19.667 100 77 154 3 2067171728 38165872 23399040
23:39:33 2657 8192000000 10988904848 11406254080 2008720016 19.691 100 82 161 0 2075407696 40133312 26554368
23:39:44 3835 8192000000 10982358944 11411062784 2013634720 19.730 100 78 149 1 2077239680 39785152 23819808
23:39:57 1948 8192000000 10985203840 11404328960 1991475840 19.555 99 83 165 3 2061530096 44906816 25147440
23:40:06 5170 8192000000 10988261568 11416244224 2011857952 19.716 100 65 130 1 2074097296 42333888 19905456
23:40:18 1913 8192000000 10979876208 11396837376 1992570608 19.564 99 89 178 1 2060117952 41084352 26462992
23:40:27 4346 8192000000 10967242320 11386675200 1981439504 19.476 100 81 162 0 2050746032 44191696 25114832
23:40:43 7661 8192000000 10974205744 11387830272 1963673040 19.335 99 68 134 1 2029506432 44597760 21235632
23:41:02 8779 8192000000 10949493024 11372589056 1967618224 19.367 100 65 129 0 2034470352 46865072 19987056
23:41:17 4876 8192000000 10973616880 11393462272 1984456416 19.500 100 72 144 2 2054704848 47557392 22691040
23:41:34 4106 8192000000 10973998240 11400241152 1989509904 19.540 100 74 147 0 2062965936 49765904 23690128
23:41:51 7132 8192000000 10969720304 11397292032 1958960640 19.298 98 65 130 1 2027532496 48240704 20331152
23:42:06 1716 8192000000 10977102320 11409334272 1992313136 19.562 100 67 134 0 2068597616 54726240 21558240
23:42:16 1029 8192000000 10975702688 11387891712 1979905776 19.464 100 80 157 0 2052424688 46724208 25794704
23:42:24 4163 8192000000 10966748912 11385774080 1981094816 19.473 100 79 158 1 2050235568 44586672 24554080
23:42:35 3509 8192000000 10946783344 11360120832 1960722224 19.312 100 83 165 1 2029957232 44245456 24989552
23:42:45 2492 8192000000 10960573408 11369263104 1954050336 19.259 99 87 174 1 2027025472 46101872 26873264
23:43:00 5542 8192000000 10971226368 11379752960 1956820400 19.281 99 84 168 1 2030213872 47942192 25451280
23:43:13 4374 8192000000 10960472944 11370614784 1942782688 19.169 98 82 164 0 2016250624 48561808 24906128
23:43:25 2318 8192000000 10958812576 11370635264 1970448896 19.389 100 82 162 1 2041968592 46369824 25149872
23:43:39 3663 8192000000 10929047632 11336855552 1937776128 19.129 98 82 163 1 2005160384 43004864 24379392
23:43:50 2773 8192000000 10957154112 11372535808 1970126720 19.386 100 79 156 2 2040018992 45657488 24234784
23:44:01 9591 8192000000 10936574944 11370901504 1964711152 19.343 100 52 104 1 2026187120 44862560 16613408
23:44:21 8135 8192000000 10931001392 11365904384 1961460752 19.318 100 34 68 1 2013498912 39981472 12056688
23:44:36 8798 8192000000 10910057184 11342106624 1902928528 18.850 97 43 86 1 1957573584 40676080 13968976
23:44:58 4420 8192000000 10929984384 11355103232 1949745360 19.224 100 49 98 0 2010346912 45458640 15142912
23:45:10 5341 8192000000 10926527616 11344613376 1945651456 19.192 100 59 116 2 2005644336 41360304 18632576
23:45:24 4486 8192000000 10920484992 11336466432 1935539088 19.111 100 65 129 0 2000084272 44005232 20539952
23:45:35 2752 8192000000 10940821344 11351457792 1951306736 19.237 100 73 144 2 2019436816 45781536 22348544
23:45:46 1373 8192000000 10963990528 11367718912 1963621136 19.335 100 91 180 0 2040835568 48530992 28683440
23:45:54 7334 8192000000 10938319488 11362734080 1951288560 19.237 100 62 122 1 2022295552 51572160 19434832
23:46:18 8745 8192000000 10924168752 11347415040 1941084784 19.155 100 58 116 0 2009461488 49928864 18447840
23:46:36 6475 8192000000 10919826304 11339653120 1920424528 18.990 99 57 111 2 1990471856 51920416 18126912
23:46:51 6124 8192000000 10938612928 11362009088 1944231280 19.181 100 57 114 0 2016711472 53214768 19265424
23:47:05 6168 8192000000 10938899136 11373187072 1950988160 19.234 100 44 88 0 2022643632 56159440 15496032
23:47:21 6178 8192000000 10927735936 11372306432 1953133184 19.251 100 37 74 1 2018854896 52801184 12920528
23:47:41 15482 8192000000 10919035056 11362476032 1949471440 19.222 100 31 62 1 2009641392 48978592 11191360
23:48:22 13068 8192000000 10928406800 11366432768 1953500064 19.254 100 34 68 2 2012972416 48465376 11006976
23:48:47 7770 8192000000 10937143424 11376762880 1960797776 19.312 100 51 102 1 2026626336 48364496 17464064
23:49:01 7193 8192000000 10959497632 11387236352 1969791312 19.384 100 65 131 3 2039089840 48533696 20764832
23:49:15 5761 8192000000 10969231552 11389489152 1967686352 19.367 100 69 138 2 2041670368 52303504 21680512
23:49:31 3091 8192000000 10953064944 11388735488 1965603584 19.351 100 59 116 1 2038854608 54670928 18580096
23:49:41 9129 8192000000 10950270480 11387969536 1945152048 19.188 99 40 80 3 2014741824 56069824 13519952
23:50:00 20192 8192000000 10925457024 11384414208 1956911008 19.281 100 33 63 1 2021148736 52703856 11533872
23:50:30 13645 8192000000 10890636816 11340222464 1928909216 19.058 100 26 52 1 1981545360 43329408 9306736
23:50:50 7141 8192000000 10901000960 11342344192 1916872672 18.962 99 35 69 1 1967374512 38992880 11508960
23:51:06 20088 8192000000 10900009600 11347705856 1938620416 19.136 100 21 42 2 1987697360 41676240 7400704
23:51:40 27654 8192000000 10917620480 11369304064 1952803520 19.249 100 25 50 1 2003982352 42472464 8706368
23:52:22 19963 8192000000 10885425344 11333742592 1902947952 18.850 98 20 40 6 1941711296 31790224 6973120
23:53:36 18435 8192000000 10897289984 11349192704 1930149216 19.068 99 35 70 1 1976305600 35050512 11105872
23:54:05 31018 8192000000 10882459568 11343982592 1922973472 19.011 99 12 24 0 1950989840 23696992 4319376
23:54:53 48636 8192000000 10909940048 11362148352 1940237728 19.149 100 9 18 0 1974063984 30927632 2898624
23:55:48 38774 8192000000 10884968064 11365011456 1940312208 19.149 100 8 16 1 1970102224 27448144 2341872
23:56:40 80340 8192000000 10916937456 11380858880 1963506240 19.334 100 19 38 0 1982623888 14140352 4977296
23:58:07 49985 8192000000 10890191920 11335794688 1918095904 18.972 97 30 60 2 1940618288 14232016 8290368
23:59:04 56839 8192000000 10893732016 11358203904 1935558176 19.111 99 13 26 2 1962061696 22675824 3827696
00:00:09 105339 8192000000 10879775824 11341545472 1866101232 18.553 95 15 30 0 1885536416 15652608 3782576
00:03:16 133461 8192000000 10895653136 11355766784 1958638768 19.295 100 31 63 0 1982252736 14585040 9028928
00:05:38 24098 8192000000 10902032896 11370778624 1971647200 19.399 100 28 56 1 1992036064 12539504 7849360
00:06:19 17581 8192000000 10906906832 11361939456 1956177344 19.276 99 23 46 0 1974874752 12397280 6300128
00:06:50 21140 8192000000 10909071744 11350618112 1936548080 19.119 98 53 104 2 1960959920 9570496 14841344
00:07:23 28751 8192000000 10898752976 11361681408 1946806448 19.201 99 32 64 4 1965657456 9192848 9658160
00:08:11 52165 8192000000 10892472064 11367669760 1967893168 19.369 100 19 38 1 1985947408 12180864 5873376
00:09:09 133885 8192000000 10904687664 11383828480 1965676336 19.351 99 11 22 0 1978061104 9272032 3112736
00:11:32 32488 8192000000 10903111552 11379867648 1983071424 19.489 100 18 36 0 1999841024 11668224 5101376
00:12:11 13893 8192000000 10886191936 11365253120 1941590992 19.159 98 5 11 0 1952100720 8793712 1716016
00:12:31 25644 8192000000 10920202432 11382812672 1983373056 19.491 100 19 38 0 1998582224 9888848 5320320
00:13:09 68810 8192000000 10919200128 11399258112 1990981824 19.552 100 15 30 0 2007261408 11394592 4884992
00:15:15 53860 8192000000 10927929440 11392700416 1988537184 19.532 100 23 46 0 2005377520 10111456 6728880
00:16:16 35417 8192000000 10912487360 11385114624 1969437984 19.381 99 31 62 0 1987652688 9487312 8727392
00:17:04 47780 8192000000 10905754960 11391553536 1976096544 19.434 100 9 18 0 1991721472 13269648 2355280
00:18:48 61782 8192000000 10894995824 11386769408 1911337392 18.917 96 9 18 0 1929397312 15513856 2546064
00:20:06 63388 8192000000 10920511520 11382743040 1948629408 19.216 98 24 48 0 1967117328 11711216 6776704
00:21:15 82499 8192000000 10907901904 11379822592 1920714384 18.993 97 16 32 1 1936571744 11668672 4188688
00:22:50 37852 8192000000 10938873840 11384307712 1950506160 19.231 98 36 71 2 1970054448 9039632 10508656
00:23:37 42304 8192000000 10904711552 11383508992 1948003872 19.211 98 18 34 4 1965344224 12067424 5272928
00:24:27 102812 8192000000 10894106496 11362205696 1876230864 18.635 95 7 13 1 1891517424 13310832 1975728
00:26:19 7928 8192000000 10903844944 11355865088 1951139472 19.236 99 51 101 2 1975080800 9961408 13979920
00:26:37 64326 8192000000 10905473744 11372150784 1929261632 19.061 98 32 64 1 1952548384 14395184 8891568
00:27:53 88268 8192000000 10881536480 11338563584 1794868400 17.972 91 8 16 0 1805945408 9039200 2037808
00:29:28 26356 8192000000 10869776096 11329613824 1900365408 18.829 98 18 36 1 1919309120 13836320 5107392
00:30:01 72109 8192000000 10879724816 11362324480 1881060096 18.674 97 15 30 2 1902271248 16962352 4248800
00:31:20 74019 8192000000 10878419952 11349950464 1905952992 18.874 98 10 20 1 1932170640 24054896 2162752
00:32:50 74699 8192000000 10840401856 11292516352 1874792976 18.623 96 38 76 0 1897254512 11097184 11364352
00:34:11 42173 8192000000 10860337200 11322056704 1908478928 18.894 99 34 68 3 1927111744 8467328 10165488
00:35:07 55927 8192000000 10852459760 11326402560 1917413680 18.966 99 29 58 0 1936980448 11607632 7959136
00:36:09 54709 8192000000 10869509408 11328393216 1917910320 18.970 99 14 25 1 1928116064 6518448 3687296
00:37:30 57785 8192000000 10857594256 11335434240 1933407936 19.094 100 5 10 1 1942709648 8071008 1230704
00:38:34 60516 8192000000 10895323440 11360808960 1933021776 19.091 99 17 34 0 1950702512 13371344 4309392
00:39:46 56780 8192000000 10901446384 11359395840 1949701248 19.224 99 30 60 1 1972321200 13834912 8785040
00:40:49 98279 8192000000 10886486368 11364798464 1908773600 18.897 97 19 35 1 1930693552 17126384 4793568
00:42:44 36366 8192000000 10895207680 11360919552 1940653952 19.152 99 23 47 0 1969379456 21557568 7167936
00:43:39 47784 8192000000 10879351808 11327279104 1891821152 18.760 97 24 45 0 1911797392 12613568 7362672
00:44:38 34415 8192000000 10872919200 11335991296 1926686288 19.040 99 26 51 0 1946874064 12746416 7441360
00:45:22 53214 8192000000 10853056032 11321323520 1868557952 18.573 96 28 56 1 1893309600 16717488 8034160
00:46:33 58995 8192000000 10869845904 11332849664 1903996032 18.858 98 20 40 2 1920382832 11112032 5274768
00:47:41 88723 8192000000 10869328128 11347259392 1927584720 19.048 99 17 34 0 1942698192 10313616 4799856
00:49:18 94172 8192000000 10888915792 11348025344 1915275152 18.949 98 16 32 1 1932741696 12573344 4893200
00:50:58 44572 8192000000 10897332672 11355598848 1937940448 19.130 99 33 66 2 1957889168 10514960 9433760
00:51:49 59097 8192000000 10885030288 11361886208 1955978464 19.274 100 23 46 0 1970689776 8279520 6431792
00:53:00 83136 8192000000 10915401072 11371257856 1912383200 18.926 97 31 62 2 1932369856 11544416 8442240
00:54:36 28896 8192000000 10896935856 11365761024 1960810288 19.312 100 35 70 4 1985489920 14667344 10012288
00:55:19 38049 8192000000 10897200128 11361435648 1939716720 19.144 99 28 54 5 1958939104 11699248 7523136
00:56:04 154516 8192000000 10891063152 11360567296 1907647552 18.888 97 22 44 1 1929122992 14915264 6560176
00:58:44 80519 8192000000 10896871616 11371360256 1916813392 18.961 97 15 30 1 1934872464 13853568 4205504
01:00:15 30549 8192000000 10926006256 11376001024 1939413840 19.142 98 20 40 1 1956174816 10899472 5861504
01:00:53 26364 8192000000 10930829520 11389681664 1978631200 19.454 100 34 68 2 2003832368 16095840 9105328
01:01:28 78693 8192000000 10924553936 11384897536 1940432784 19.150 98 21 42 2 1966960192 20985824 5541584
01:02:55 12249 8192000000 10935230448 11386114048 1987253328 19.522 100 43 86 0 2007821776 8031792 12536656
01:03:15 30738 8192000000 10923333152 11386654720 1975945504 19.433 99 44 88 2 2001916688 13664224 12306960
01:04:00 76628 8192000000 10927488656 11410595840 1974443824 19.421 99 16 32 0 1993414144 14251296 4719024
01:05:29 50221 8192000000 10915031792 11381129216 1976497360 19.437 99 31 62 2 1998631392 13271360 8862672
01:06:27 148322 8192000000 10892541104 11372023808 1889781936 18.744 95 22 44 0 1903492080 7841840 5868304
01:09:01 37083 8192000000 10917215008 11380432896 1985156912 19.506 100 39 76 1 2004535088 7677712 11700464
01:09:52 74133 8192000000 10899614128 11390197760 1972218976 19.403 99 13 26 0 1987113600 10897392 3997232
01:11:48 62428 8192000000 10902567072 11385090048 1979535632 19.461 100 18 35 3 1998122736 13575520 5011584
01:12:57 67106 8192000000 10915791280 11391811584 1971387232 19.396 99 24 48 0 1992100128 14289616 6423280
01:14:10 68329 8192000000 10916863456 11380494336 1951324064 19.237 98 19 36 0 1964645696 8408464 4913168
01:15:24 63269 8192000000 10892768368 11377082368 1927719152 19.049 97 11 22 0 1939363664 8726064 2918448
01:16:34 25545 8192000000 10893078704 11370938368 1957547424 19.287 99 18 36 1 1970733216 7918656 5267136
01:17:36 46963 8192000000 10872883008 11337003008 1893978224 18.778 97 25 49 0 1913497248 11450016 8069008
01:18:39 47899 8192000000 10877685184 11340877824 1893992048 18.778 97 18 36 1 1907912960 8893152 5027760
01:19:33 87904 8192000000 10857217120 11337125888 1866034032 18.552 96 17 34 1 1883416928 12847184 4535712
01:21:07 57584 8192000000 10861994016 11327963136 1864337200 18.538 96 6 12 0 1879089616 13430720 1321696
01:22:18 89774 8192000000 10856911344 11331743744 1902654192 18.848 98 14 28 1 1921565984 15322544 3589248
01:24:36 99055 8192000000 10879685392 11358334976 1894977568 18.786 97 23 46 1 1918881792 17073600 6830624
01:26:36 41138 8192000000 9462901712 9756631040 575421984 6.563 30 10 20 0 580791200 2922960 2446256

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 09-01-2021 01:28:02 to 09-01-2021 01:28:33.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 187 v_add_invoice_to_stock 335544517
except 10 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:01, from 09-01-2021 01:28:34 to 09-01-2021 01:28: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          239939
MON$OLDEST_ACTIVE               240188
MON$OLDEST_SNAPSHOT             240188
MON$NEXT_TRANSACTION            240188
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                       2043808
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.33402 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33402 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33402 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33402 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 ---
:593: 
:594: mscs-test-161.budzdorov.ru    Sat Jan  9 01:27:22 2021
:595:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:596: 
:597: 
:598: mscs-test-161.budzdorov.ru    Sat Jan  9 01:27:22 2021
:599:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:600: 
:601: 
:602: mscs-test-161.budzdorov.ru    Sat Jan  9 01:27:22 2021
:603:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:604: 
--- end of diff output ---

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

09.01.21 01:28: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-01-09 01:28:39 No severe PSQL-related problems occured
09.01.21 01:28:40. End of report.