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

Hardware and OS info

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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-03-13 22:27:23
DTS_END                         2021-03-13 22:27:23.4860
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_ORDER(38:5) ==> X_MAKE_QSTORNO_1000_1200(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/34002
TRN_ID                          242668
ATT_ID                          689
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: 9043.26 20082 1085191
customer order: creation 179.17 367 21500
customer order: refuse 15.23 386 1827
order to supplier: creation 47.58 1310 5709
order to supplier: removal 3.54 105857 425
invoice (draft): creation 47.23 3422 5668
invoice (draft): removal 49.34 868 5921
invoice accept: apply 43.18 19455 5182
invoice accept: cancel 44.28 886 5314
customer reserve: creation 3979.41 193 477529
customer reserve: removal 4333.37 68 520004
realization accept: apply 85.08 169 10209
realization accept: cancel 80.81 118 9697
payment from customer: creation 61.43 102 7371
payment from customer: removal 6.07 84 728
payment to supplier: creation 50.46 107 6055
payment to supplier: removal 3.54 73 425
service: total inventory turnovers 5.11 1043 613
service: total monetary turnovers 7.46 32 895
service: aggregate perf. data 0.96 20063 115
service: refresh index statistics 0.03 247036 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 13-03-2021 22:29:54 to 13-03-2021 22:29:56.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 9189
TEST_TIME 2 8216
TEST_TIME 3 7396
TEST_TIME 4 7018
TEST_TIME 5 6494
TEST_TIME 6 6721
TEST_TIME 7 6183
TEST_TIME 8 6762
TEST_TIME 9 7008
TEST_TIME 10 6744
TEST_TIME 11 6847
TEST_TIME 12 6889
TEST_TIME 13 6816
TEST_TIME 14 6847
TEST_TIME 15 6978
TEST_TIME 16 7148
TEST_TIME 17 7279
TEST_TIME 18 7650
TEST_TIME 19 7774
TEST_TIME 20 7974
TEST_TIME 21 8153
TEST_TIME 22 8536
TEST_TIME 23 8611
TEST_TIME 24 8614
TEST_TIME 25 8992
TEST_TIME 26 9284
TEST_TIME 27 9820
TEST_TIME 28 9715
TEST_TIME 29 10990
TEST_TIME 30 11180
TEST_TIME 31 11316
TEST_TIME 32 11104
TEST_TIME 33 10885
TEST_TIME 34 10908
TEST_TIME 35 10976
TEST_TIME 36 11013
TEST_TIME 37 10801
TEST_TIME 38 10575
TEST_TIME 39 10387
TEST_TIME 40 10267
TEST_TIME 41 10189
TEST_TIME 42 10144
TEST_TIME 43 9995
TEST_TIME 44 10006
TEST_TIME 45 9894
TEST_TIME 46 9795
TEST_TIME 47 9694
TEST_TIME 48 9879
TEST_TIME 49 9831
TEST_TIME 50 9726
TEST_TIME 51 9553
TEST_TIME 52 9575
TEST_TIME 53 9595
TEST_TIME 54 9570
TEST_TIME 55 9584
TEST_TIME 56 9487
TEST_TIME 57 9523
TEST_TIME 58 9495
TEST_TIME 59 9459
TEST_TIME 60 9449
TEST_TIME 61 9587
TEST_TIME 62 9630
TEST_TIME 63 9594
TEST_TIME 64 9588
TEST_TIME 65 9666
TEST_TIME 66 9593
TEST_TIME 67 9644
TEST_TIME 68 9762
TEST_TIME 69 9688
TEST_TIME 70 9630
TEST_TIME 71 9541
TEST_TIME 72 9517
TEST_TIME 73 9425
TEST_TIME 74 9445
TEST_TIME 75 9395
TEST_TIME 76 9348
TEST_TIME 77 9292
TEST_TIME 78 9258
TEST_TIME 79 9295
TEST_TIME 80 9275
TEST_TIME 81 9241
TEST_TIME 82 9276
TEST_TIME 83 9342
TEST_TIME 84 9319
TEST_TIME 85 9266
TEST_TIME 86 9252
TEST_TIME 87 9395
TEST_TIME 88 9387
TEST_TIME 89 9371
TEST_TIME 90 9401
TEST_TIME 91 9339
TEST_TIME 92 9341
TEST_TIME 93 9264
TEST_TIME 94 9201
TEST_TIME 95 9228
TEST_TIME 96 9197
TEST_TIME 97 9140
TEST_TIME 98 9104
TEST_TIME 99 9068
TEST_TIME 100 9043
TEST_TIME 101 9022
TEST_TIME 102 9080
TEST_TIME 103 9071
TEST_TIME 104 9113
TEST_TIME 105 9157
TEST_TIME 106 9141
TEST_TIME 107 9124
TEST_TIME 108 9188
TEST_TIME 109 9198
TEST_TIME 110 9224
TEST_TIME 111 9302
TEST_TIME 112 9346
TEST_TIME 113 9343
TEST_TIME 114 9266
TEST_TIME 115 9238
TEST_TIME 116 9211
TEST_TIME 117 9207
TEST_TIME 118 9153
TEST_TIME 119 9112
TEST_TIME 120 9047

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 13-03-2021 22:29:58 to 13-03-2021 22:30:01.

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 1526266 1526266 0 0.00 0 19383 7 0 0
doc_list_biud 1526264 1526264 0 0.00 0 74654 29 0 0
sp_add_invoice_to_stock 5340 5182 158 2.95 33 211573 19455 0 158
sp_cancel_adding_invoice 5314 5314 0 0.00 5 59490 886 0 0
sp_cancel_client_order 1827 1827 0 0.00 5 14270 387 0 0
sp_cancel_customer_reserve 520004 520004 0 0.00 1 26220 69 0 0
sp_cancel_pay_from_customer 728 728 0 0.00 3 8134 85 0 0
sp_cancel_pay_to_supplier 425 425 0 0.00 3 6502 73 0 0
sp_cancel_supplier_invoice 5934 5921 13 0.21 2 74681 868 0 13
sp_cancel_supplier_order 425 425 0 0.00 8 1254809 105858 0 0
sp_cancel_write_off 9697 9697 0 0.00 1 11167 119 0 0
sp_client_order 21500 21500 0 0.00 3 26608 367 0 0
sp_customer_reserve 477529 477529 0 0.00 0 35290 194 0 0
sp_fill_shopping_cart 32844 32844 0 0.00 1 23699 41 0 0
sp_fill_shopping_cart_clo_res 477509 477509 0 0.00 0 14873 14 0 0
sp_get_clo_for_invoice 5161 5161 0 0.00 0 27723 307 0 0
sp_kill_cost_storno 16164 16164 0 0.00 0 8109 64 0 0
sp_kill_qstorno_ret_qs2qd 1056051 1056051 0 0.00 0 74651 37 0 0
sp_kill_qty_storno 558558 558558 0 0.00 0 74653 79 0 0
sp_lock_selected_doc 21377 21377 0 0.00 0 8370 5 0 0
sp_make_cost_storno 28796 28796 0 0.00 0 12854 50 0 0
sp_multiply_rows_for_pdistr 28796 28796 0 0.00 0 8020 28 0 0
sp_multiply_rows_for_qdistr 21500 21500 0 0.00 0 11666 180 0 0
sp_pay_from_customer 7371 7371 0 0.00 4 8626 103 0 0
sp_pay_to_supplier 6055 6055 0 0.00 4 12926 107 0 0
sp_payment_common 13426 13426 0 0.00 1 8460 24 0 0
sp_qd_handle_on_cancel_clo 1827 1827 0 0.00 0 14257 349 0 0
sp_qd_handle_on_invoice_upd_sts 10475 10475 0 0.00 0 15407 345 0 0
sp_qd_handle_on_reserve_upd_sts 10209 10209 0 0.00 0 18595 54 0 0
sp_reserve_write_off 10209 10209 0 0.00 6 18788 169 0 0
sp_supplier_invoice 5668 5668 0 0.00 6 107800 3422 0 0
sp_supplier_order 5709 5709 0 0.00 6 27359 1311 0 0
srv_aggregate_perf_data 115 115 0 0.00 1824 509288 20063 0 0
srv_fill_mon_cache_memory 183 183 0 0.00 1192 149866 28614 0 0
srv_find_qd_qs_mism 1035145 1035145 0 0.00 0 19382 6 0 0
srv_make_invnt_saldo 613 613 0 0.00 20 54562 1044 0 0
srv_make_money_saldo 895 895 0 0.00 1 1966 32 0 0
srv_recalc_idx_stat 4 4 0 0.00 92701 497636 247036 0 0
t$perf-abend:sp_add_invoice_to_stock 158 158 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 13 13 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5182 5182 0 0.00 0 11136 178 0 0
t$perf-norm:sp_cancel_adding_invoice 435 435 0 0.00 0 4581 96 0 0
t$perf-norm:sp_cancel_client_order 1827 1827 0 0.00 0 3333 19 0 0
t$perf-norm:sp_cancel_customer_reserve 724 724 0 0.00 0 3810 20 0 0
t$perf-norm:sp_cancel_pay_from_customer 728 728 0 0.00 0 3480 14 0 0
t$perf-norm:sp_cancel_pay_to_supplier 425 425 0 0.00 0 3914 20 0 0
t$perf-norm:sp_cancel_supplier_invoice 427 427 0 0.00 0 6076 29 0 0
t$perf-norm:sp_cancel_supplier_order 425 425 0 0.00 0 50970 1744 0 0
t$perf-norm:sp_cancel_write_off 1016 1016 0 0.00 0 5047 17 0 0
t$perf-norm:sp_client_order 21500 21500 0 0.00 0 15060 21 0 0
t$perf-norm:sp_customer_reserve 986 986 0 0.00 0 2784 11 0 0
t$perf-norm:sp_pay_from_customer 7371 7371 0 0.00 0 5435 11 0 0
t$perf-norm:sp_pay_to_supplier 6055 6055 0 0.00 0 4303 14 0 0
t$perf-norm:sp_reserve_write_off 10209 10209 0 0.00 0 16478 17 0 0
t$perf-norm:sp_supplier_invoice 5668 5668 0 0.00 0 7239 22 0 0
t$perf-norm:sp_supplier_order 5709 5709 0 0.00 0 13025 22 0 0
t$perf-norm:srv_aggregate_perf_data 115 115 0 0.00 0 329 17 0 0
t$perf-norm:srv_fill_mon_cache_memory 183 183 0 0.00 0 313 4 0 0
t$perf-norm:srv_make_invnt_saldo 613 613 0 0.00 0 879 21 0 0
t$perf-norm:srv_make_money_saldo 895 895 0 0.00 0 3263 19 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 3 70 21 0 0
v_add_invoice_to_stock 10638 10322 316 2.97 0 3065 16 0 316
v_all_customers 38624 38624 0 0.00 0 18 1 0 0
v_all_suppliers 31282 31282 0 0.00 0 23 1 0 0
v_all_wares 42992 42992 0 0.00 0 17 1 0 0
v_cancel_adding_invoice 870 870 0 0.00 0 240 6 0 0
v_cancel_client_order 3654 3654 0 0.00 0 2904 5 0 0
v_cancel_customer_prepayment 1456 1456 0 0.00 0 1061 5 0 0
v_cancel_customer_reserve 1448 1448 0 0.00 0 1307 6 0 0
v_cancel_payment_to_supplier 850 850 0 0.00 0 1928 6 0 0
v_cancel_supplier_invoice 880 854 26 2.95 0 3607 24 0 26
v_cancel_supplier_order 850 850 0 0.00 0 291 4 0 0
v_cancel_write_off 2032 2032 0 0.00 0 7203 17 0 0
v_max_id_clo_ord 5705 5705 0 0.00 0 250 1 0 0
v_max_id_clo_res 986 986 0 0.00 0 711 9 0 0
v_max_id_ord_sup 5643 5643 0 0.00 0 3506 3 0 0
v_max_non_paid_invoice 1762 1762 0 0.00 0 3963 5 0 0
v_max_non_paid_realizn 4103 4103 0 0.00 0 4727 5 0 0
v_min_id_clo_ord 5705 5705 0 0.00 0 3940 6 0 0
v_min_id_clo_res 986 986 0 0.00 0 10465 26 0 0
v_min_id_ord_sup 5643 5643 0 0.00 0 7888 8 0 0
v_min_non_paid_invoice 6055 6055 0 0.00 0 7864 13 0 0
v_min_non_paid_realizn 7371 7371 0 0.00 0 7958 14 0 0
v_our_firm 10904 10904 0 0.00 0 32 1 0 0
v_reserve_write_off 20418 20418 0 0.00 0 2502 4 0 0
x_lock_depdocs_on_canc_invoice 10808 10808 0 0.00 0 16538 152 0 0
x_lock_depdocs_on_canc_sup_ord 425 425 0 0.00 0 3848 319 0 0
x_make_qstorno_1000_1200 5709 5709 0 0.00 2 27301 1222 0 0
x_make_qstorno_1200_2000 5668 5668 0 0.00 3 107794 3275 0 0
x_make_qstorno_2100_3300 477528 477528 0 0.00 0 30831 177 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 13-03-2021 22:30:02 to 13-03-2021 22:30:06.

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:27 5 8192000000 8802271248 8813776896 8233680 0.100 2 1 2 0 8353088 56848 62560
19:57:33 11294 8192000000 10186305504 10487468032 888488096 9.784 71 47 94 0 907339440 2629824 16221520
19:57:52 32641 8192000000 10329907552 10649419776 1372398272 14.349 100 79 159 0 1403494048 4661056 26434720
19:58:47 25339 8192000000 10400800224 10727985152 1450714912 15.044 100 83 166 0 1484254128 6525328 27013888
19:59:23 20424 8192000000 10441975888 10769739776 1489641504 15.386 100 88 176 2 1525882560 7559792 28681264
20:00:01 24193 8192000000 10461135216 10795606016 1511727568 15.578 100 91 182 0 1550096752 9021392 29347792
20:00:34 23157 8192000000 10469399760 10809618432 1523920592 15.684 100 92 184 1 1563572896 9873056 29779248
20:01:08 18226 8192000000 10489144752 10831331328 1543212768 15.851 100 87 174 3 1581021920 10274256 27534896
20:01:42 27587 8192000000 10525236272 10874859520 1576488512 16.138 100 85 170 1 1613965600 10521376 26955712
20:02:23 12235 8192000000 10540778544 10895376384 1596723136 16.311 100 78 156 2 1631257952 10892352 23642464
20:02:48 16757 8192000000 10568323168 10927456256 1624669696 16.550 100 84 168 1 1661646944 11562656 25414592
20:03:12 11258 8192000000 10581447264 10946301952 1643928096 16.713 100 75 150 0 1678405520 12189264 22288160
20:03:31 15307 8192000000 10612002544 10975055872 1661566144 16.862 100 75 150 2 1696283536 12303360 22414032
20:03:53 14081 8192000000 10618062992 10985603072 1678070240 17.001 100 79 159 0 1714151136 13019456 23061440
20:04:16 11481 8192000000 10647980608 11016826880 1709300032 17.263 100 81 162 3 1744793344 12252512 23240800
20:04:36 8125 8192000000 10652746496 11025698816 1714957360 17.310 100 78 156 2 1750324416 12709184 22657872
20:04:52 8374 8192000000 10667865600 11040825344 1722853360 17.376 100 75 149 1 1755901088 12120064 20927664
20:05:07 7561 8192000000 10667844384 11050020864 1734602688 17.474 100 68 136 1 1765816704 12073920 19140096
20:05:24 5242 8192000000 10687399664 11066417152 1750624176 17.607 100 77 155 1 1785055872 12579936 21851760
20:05:35 3706 8192000000 10702591040 11081633792 1769901840 17.766 100 89 178 2 1808450656 13248080 25300736
20:05:46 4258 8192000000 10705883296 11086471168 1770829056 17.774 100 85 170 2 1807618192 12584544 24204592
20:05:58 6390 8192000000 10716479904 11096145920 1779545568 17.846 100 86 172 1 1817221888 13512272 24164048
20:06:12 5536 8192000000 10732565184 11108376576 1786232864 17.901 100 80 158 2 1822313872 13587776 22493232
20:06:24 3088 8192000000 10733701440 11115487232 1795859744 17.980 100 88 174 3 1834184240 13553056 24771440
20:06:34 3644 8192000000 10734869568 11116077056 1800976752 18.022 100 86 174 1 1837963024 12126448 24859824
20:06:45 1625 8192000000 10748229664 11127291904 1803517792 18.043 100 94 188 1 1844306976 13639680 27149504
20:06:53 9607 8192000000 10741600192 11127058432 1802884848 18.038 100 82 165 1 1840150864 14705568 22560448
20:07:09 3812 8192000000 10735898336 11122040832 1807469584 18.075 100 76 150 1 1840885376 13067808 20347984
20:07:20 2291 8192000000 10765267408 11145990144 1821327232 18.189 100 90 179 1 1859729840 12894960 25507648
20:07:29 3127 8192000000 10767406336 11152719872 1829070624 18.252 100 84 168 0 1865909760 13025760 23813376
20:07:38 2155 8192000000 10775687536 11163570176 1832987872 18.284 100 94 188 0 1874745120 14698576 27058672
20:07:47 1788 8192000000 10781868256 11166068736 1835742624 18.306 100 92 182 1 1874730064 13719216 25268224
20:07:55 2162 8192000000 10779037856 11164463104 1842414944 18.360 100 91 182 0 1881388496 13560352 25413200
20:08:03 1851 8192000000 10795358896 11178672128 1847445120 18.401 100 89 178 0 1886224128 13944736 24834272
20:08:12 1807 8192000000 10787641136 11174604800 1847002096 18.398 100 87 173 0 1886392928 13987360 25403472
20:08:20 2902 8192000000 10796281552 11182698496 1850903776 18.429 100 86 171 1 1888142288 13247488 23991024
20:08:30 1691 8192000000 10802613776 11188875264 1855114048 18.464 100 95 191 1 1896793504 14296592 27382864
20:08:38 1639 8192000000 10805628400 11193376768 1858489680 18.491 100 90 180 0 1898091504 13866240 25735584
20:08:46 1374 8192000000 10806973776 11193319424 1859372656 18.498 100 94 189 2 1898306432 12620976 26312800
20:08:54 1448 8192000000 10811781744 11198996480 1865543104 18.548 100 94 188 0 1904882304 12746880 26592320
20:09:01 12488 8192000000 10794150704 11196825600 1862407024 18.523 100 64 127 1 1891570656 11135440 18028192
20:09:21 2559 8192000000 10791426192 11197939712 1864669504 18.541 100 61 121 0 1892050560 10737984 16643072
20:09:32 1730 8192000000 10803031840 11203731456 1870076128 18.585 100 70 135 1 1899407328 9572656 19758544
20:09:40 4215 8192000000 10790414864 11202314240 1866473952 18.556 100 50 100 0 1890658800 10257408 13927440
20:09:51 1725 8192000000 10797575280 11205316608 1873680800 18.614 100 73 146 4 1904897984 10242880 20974304
20:09:59 5770 8192000000 10781975168 11204001792 1871392464 18.596 100 37 74 1 1891418032 9804096 10221472
20:10:13 6958 8192000000 10771745984 11200884736 1873784544 18.615 100 26 50 1 1888141888 6674416 7682928
20:10:28 8419 8192000000 10788709792 11209334784 1874148544 18.618 100 29 58 1 1889836896 7155856 8532496
20:10:42 10424 8192000000 10784942512 11209433088 1872371392 18.603 100 20 40 2 1884434976 6599792 5463792
20:10:59 7639 8192000000 10793477232 11220832256 1878446144 18.653 100 24 48 0 1895740496 11168080 6126272
20:11:14 10937 8192000000 10786357856 11212578816 1879635472 18.662 100 22 45 3 1892173104 6272752 6264880
20:11:32 10724 8192000000 10798682128 11222425600 1884629744 18.702 100 26 50 2 1896783504 5296720 6857040
20:11:52 75866 8192000000 10815668480 11239661568 1886770512 18.720 100 36 72 2 1903256032 6105840 10379680
20:13:18 6400 8192000000 10811578368 11238850560 1889115648 18.739 100 34 66 3 1904014576 5362720 9536208
20:13:30 7921 8192000000 10810410448 11232309248 1890808304 18.752 100 27 55 1 1905116592 6352704 7955584
20:13:46 5146 8192000000 10811165824 11238215680 1890393200 18.749 100 35 70 1 1907861728 7538752 9929776
20:13:58 6042 8192000000 10799532416 11235930112 1892059072 18.762 100 22 44 1 1904849968 6625584 6165312
20:14:12 3356 8192000000 10809334608 11240198144 1895237728 18.788 100 26 52 0 1908384800 6141920 7005152
20:14:23 5464 8192000000 10802716432 11239280640 1895176368 18.787 100 34 68 2 1911969008 6641488 10151152
20:14:37 5298 8192000000 10808800704 11242541056 1895599664 18.791 100 37 74 0 1912589968 5885296 11105008
20:14:48 6583 8192000000 10802128016 11237658624 1893799216 18.776 100 21 42 1 1905550672 5668240 6083216
20:15:02 6991 8192000000 10808029936 11243823104 1893023040 18.770 100 17 34 1 1903728112 5804880 4900192
20:15:19 6187 8192000000 10814460896 11248635904 1899190464 18.820 100 27 54 3 1913342240 6842016 7309760
20:15:31 11274 8192000000 10805933616 11247034368 1899453680 18.822 100 14 28 0 1909878512 6628960 3795872
20:15:49 11889 8192000000 10800000544 11235074048 1874793376 18.623 99 11 22 1 1883468208 5862368 2812464
20:16:07 13606 8192000000 10806741360 11243782144 1894451264 18.782 100 14 28 1 1904082992 5382432 4249296
20:16:27 58645 8192000000 10800973264 11217903616 1809265856 18.090 95 27 50 2 1822938848 5253968 8419024
20:17:32 30307 8192000000 10802728208 11235528704 1878066704 18.649 99 33 64 3 1891188096 4826448 8294944
20:18:09 8578 8192000000 10789100768 11207229440 1847842992 18.405 98 35 70 2 1864667216 7509344 9314880
20:18:26 4422 8192000000 10794836144 11216556032 1868724720 18.574 100 34 66 2 1889466992 11129616 9612656
20:18:37 7013 8192000000 10761948512 11181264896 1810758128 18.102 97 30 60 0 1825670912 6425280 8487504
20:18:50 5506 8192000000 10741921168 11164528640 1811725856 18.110 99 37 73 1 1829415712 6975296 10714560
20:19:02 8132 8192000000 10740878416 11164090368 1801381472 18.025 98 22 44 2 1813971584 5233904 7356208
20:19:17 8020 8192000000 10721212080 11142811648 1743992976 17.552 95 18 35 0 1753943504 5305328 4645200
20:19:32 8827 8192000000 10724857584 11148304384 1793274528 17.959 99 21 41 1 1809474608 10587104 5612976
20:19:47 6793 8192000000 10729884416 11144876032 1780227488 17.851 98 28 55 2 1793430704 5355136 7848080
20:20:00 7493 8192000000 10656286480 11075698688 1694467712 17.139 96 19 38 0 1705540160 5295904 5776544
20:20:17 13464 8192000000 10673234016 11089330176 1689529584 17.097 95 27 54 2 1702819952 4732416 8557952
20:20:38 13116 8192000000 10685339216 11102134272 1750777984 17.608 98 17 34 0 1765768032 10003344 4986704
20:20:58 9863 8192000000 10701846544 11119599616 1759693760 17.682 98 27 54 0 1773362448 5446592 8222096
20:21:14 18057 8192000000 10706241904 11099660288 1741028368 17.527 97 12 24 0 1754442112 9801856 3611888
20:21:39 61479 8192000000 10715001104 11141681152 1779882624 17.849 98 29 58 1 1793677424 4833232 8961568
20:22:53 13790 8192000000 10733864960 11158638592 1823890592 18.209 100 24 48 0 1837588560 6145600 7552368
20:23:16 5454 8192000000 10761302128 11179548672 1837786624 18.323 100 32 64 0 1853970928 6941616 9242688
20:23:28 6800 8192000000 10743407344 11166158848 1816957872 18.153 99 18 36 0 1827588448 5474480 5156096
20:23:44 6309 8192000000 10747660400 11169992704 1818818144 18.168 99 37 72 2 1835751104 6039744 10893216
20:23:57 5764 8192000000 10750263264 11170643968 1820347088 18.181 99 27 54 2 1837790144 9836176 7606880
20:24:12 10572 8192000000 10761443968 11186274304 1840073536 18.341 100 16 32 0 1850606688 6014640 4518512
20:24:32 5856 8192000000 10773419888 11192115200 1850327184 18.425 100 23 44 3 1863304576 5696416 7280976
20:24:44 8121 8192000000 10777621792 11199680512 1841083984 18.350 99 21 42 1 1853142112 5613152 6444976
20:24:59 9330 8192000000 10771581488 11199803392 1859712720 18.501 100 24 48 1 1872031888 5452752 6866416
20:25:15 6358 8192000000 10780983712 11206008832 1865424032 18.547 100 23 46 1 1877867712 6044944 6398736
20:25:28 12296 8192000000 10792544560 11214213120 1873524416 18.613 100 22 44 0 1889214048 9469856 6219776
20:25:47 7432 8192000000 10783162944 11215257600 1875504240 18.629 100 18 36 2 1887146000 5708384 5933376
20:26:01 10893 8192000000 10791358960 11219734528 1876148912 18.634 100 13 26 2 1885135776 5389056 3597808
20:26:18 53407 8192000000 10805643664 11228880896 1881574176 18.678 100 28 56 4 1895204608 5264000 8366432
20:27:27 19610 8192000000 10856892320 11268648960 1912922224 18.930 100 56 112 1 1935509072 7262352 15324496
20:27:58 15389 8192000000 10863265296 11283107840 1928941056 19.058 100 64 129 1 1955360896 8263328 18156512
20:28:24 1894 8192000000 10867919264 11286671360 1936679760 19.120 100 67 126 2 1963913152 8426944 18806448
20:28:33 8031 8192000000 10872699760 11296247808 1941261600 19.157 100 63 126 1 1970468224 10371936 18834688
20:28:51 21678 8192000000 10882152928 11310137344 1943259808 19.173 100 60 121 0 1975010160 14918464 16831888
20:29:19 10899 8192000000 10874306016 11305734144 1948818768 19.217 100 62 124 1 1977387152 10690176 17878208
20:29:38 16344 8192000000 10886143456 11312504832 1951462672 19.238 100 55 110 1 1976899280 10066112 15370496
20:30:02 6772 8192000000 10892082832 11316330496 1955709616 19.272 100 57 113 4 1981150288 8951664 16489008
20:30:17 5785 8192000000 10908251392 11323842560 1959985744 19.306 100 68 135 1 1988880768 9768720 19126304
20:30:30 22660 8192000000 10885939088 11317829632 1960068944 19.307 100 54 108 0 1985251824 9458384 15724496
20:31:02 12002 8192000000 10903639776 11332816896 1962937776 19.329 100 45 87 1 1987410288 11599952 12872560
20:31:23 21801 8192000000 10896170672 11338489856 1967337200 19.364 100 41 82 0 1995516832 16891328 11288304
20:31:55 27836 8192000000 10897630192 11333296128 1967469552 19.365 100 38 76 0 1990932608 12451280 11011776
20:32:31 13315 8192000000 10918221104 11346100224 1974913984 19.424 100 50 99 0 2002551792 12756816 14880992
20:33:00 14273 8192000000 10916918288 11356221440 1979804384 19.463 100 32 64 1 2004232480 14588688 9839408
20:33:28 5644 8192000000 10923729776 11358724096 1984044928 19.497 100 41 82 2 2009795008 13237168 12512912
20:33:44 12924 8192000000 10926604448 11362258944 1989760992 19.542 100 48 96 2 2017449024 14175360 13512672
20:34:07 9748 8192000000 10945844960 11375955968 1997862864 19.606 100 60 118 0 2033054144 18331120 16860160
20:34:28 5218 8192000000 10970875424 11390832640 2006138720 19.671 100 76 152 2 2047568592 20026112 21403760
20:34:43 7126 8192000000 10963984544 11389108224 2011096048 19.710 100 71 142 1 2052995056 21762624 20136384
20:35:04 16922 8192000000 10967422368 11395592192 1992397952 19.563 99 68 133 1 2039047616 27378208 19271456
20:35:27 4216 8192000000 10963081888 11390906368 2008240736 19.688 100 68 136 2 2050144432 21259936 20643760
20:35:39 6840 8192000000 10961355280 11392192512 2008807888 19.692 100 63 127 2 2048269744 20761408 18700448
20:35:53 7120 8192000000 10952784880 11387850752 2006949488 19.678 100 55 109 1 2042164640 18986016 16229136
20:36:09 4477 8192000000 10965404976 11395006464 2011818192 19.716 100 50 99 2 2046278608 19756224 14704192
20:36:22 8620 8192000000 10956083552 11386327040 2004805520 19.661 100 67 132 0 2046880464 21785152 20289792
20:36:39 12557 8192000000 10954731408 11393474560 2007625168 19.683 100 55 110 1 2045475488 21074544 16775776
20:37:00 9402 8192000000 10953012128 11385778176 2005135792 19.663 100 50 98 3 2038343120 18482912 14724416
20:37:18 20630 8192000000 10943453472 11377266688 1983188272 19.490 99 53 106 1 2020226560 20966320 16071968
20:37:47 14486 8192000000 10947630704 11387752448 2004300064 19.657 100 52 104 2 2042206064 22417168 15488832
20:38:10 4932 8192000000 10945064144 11385704448 1987538640 19.524 99 45 90 0 2026436128 25248752 13648736
20:38:22 6873 8192000000 10953090464 11390803968 2005074176 19.663 100 44 89 2 2043049824 24333744 13641904
20:38:36 3529 8192000000 10974145392 11403218944 2017766992 19.763 100 80 158 0 2065358832 23220256 24371584
20:38:50 14314 8192000000 10964767808 11401781248 2011721376 19.715 100 56 111 0 2052460928 24238880 16500672
20:39:33 6038 8192000000 10972828448 11410522112 2015511536 19.745 100 62 122 2 2065572896 30853648 19207712
20:39:46 9827 8192000000 10966532528 11406299136 2012899072 19.724 100 63 125 0 2064588624 32553824 19135728
20:40:04 7765 8192000000 10972262848 11407446016 2013606048 19.730 100 55 108 0 2059288432 28892144 16790240
20:40:27 5394 8192000000 10974426640 11408596992 2014850608 19.740 100 64 125 1 2062441120 28664128 18926384
20:40:40 9362 8192000000 10985607200 11418951680 2021420272 19.791 100 53 106 1 2069574320 31802048 16352000
20:40:58 4459 8192000000 10984880144 11423739904 2026282144 19.829 100 57 112 2 2076624384 33557984 16784256
20:41:14 5370 8192000000 10975668624 11411038208 2005886464 19.669 99 67 135 1 2058143120 32028192 20228464
20:41:29 4182 8192000000 11001829760 11426627584 2022629200 19.801 100 69 138 2 2076516384 32990544 20896640
20:41:41 4022 8192000000 11003257552 11429728256 2024889568 19.819 100 77 154 0 2082966720 34573536 23503616
20:41:52 3255 8192000000 10967182128 11381698560 1965511344 19.350 97 82 163 1 2026492576 36521056 24460176
20:42:02 1789 8192000000 11008645312 11423596544 2023013680 19.804 100 93 186 1 2088593344 37580432 27999232
20:42:10 2941 8192000000 10988751760 11404881920 2005718048 19.668 100 78 155 1 2068967840 39452064 23797728
20:42:22 2735 8192000000 10985314256 11405119488 1996868768 19.598 99 91 180 0 2064674816 40146000 27660048
20:42:33 4080 8192000000 11000326720 11415539712 2011486384 19.713 100 78 154 0 2075765936 40079056 24200496
20:42:46 6634 8192000000 10947021904 11372244992 1959258768 19.300 98 65 129 1 2019477200 39372464 20845968
20:42:59 2743 8192000000 10956218720 11382145024 1968397760 19.373 99 71 139 1 2029523728 39344704 21781264
20:43:09 4612 8192000000 10964919456 11391254528 1991325344 19.554 100 73 147 0 2052628864 38248944 23054576
20:43:23 4933 8192000000 10977389520 11395694592 1983914848 19.496 99 81 159 2 2047987872 38829024 25244000
20:43:37 4719 8192000000 10970273040 11394523136 1991250256 19.554 100 68 134 3 2053306672 41163088 20893328
20:43:51 3731 8192000000 10955664800 11373043712 1973512032 19.413 100 76 151 1 2038818064 41732256 23573776
20:44:02 2999 8192000000 10976086528 11387445248 1986274976 19.514 100 90 177 0 2057936944 43928512 27733456
20:44:12 6659 8192000000 10970468832 11391193088 1985709968 19.510 100 72 143 2 2050996032 42855200 22430864
20:44:28 4416 8192000000 10958396464 11390025728 1981202464 19.474 100 59 117 1 2043729680 43374720 19152496
20:44:41 2712 8192000000 10975249712 11396009984 1992317648 19.562 100 78 154 2 2060995376 43808384 24869344
20:44:51 3346 8192000000 10974830448 11399684096 1991767456 19.558 100 71 137 1 2059207824 45479296 21961072
20:45:02 4456 8192000000 10964758576 11374092288 1964782784 19.344 99 90 180 0 2041154112 47704416 28666912
20:45:14 3538 8192000000 10986887280 11404656640 1991854896 19.558 100 82 163 1 2067931824 50774240 25302688
20:45:25 1548 8192000000 10957269808 11362516992 1957126336 19.283 99 87 174 2 2033349392 48080960 28142096
20:45:33 4527 8192000000 10970891664 11387940864 1973794352 19.416 100 83 165 0 2047473568 48101776 25577440
20:45:47 1190 8192000000 10960674752 11367292928 1965188528 19.347 99 91 179 0 2039720976 46610880 27921568
20:45:55 1657 8192000000 10974664816 11385962496 1976363424 19.436 100 88 175 2 2052733968 49189760 27180784
20:46:05 1285 8192000000 10986795040 11398361088 1990347760 19.547 100 87 174 0 2067282528 49821792 27112976
20:46:14 2566 8192000000 11002367392 11411722240 1995419680 19.587 100 90 180 1 2073584432 50553984 27610768
20:46:24 2749 8192000000 10977584400 11394314240 1979388112 19.460 100 83 165 1 2055577984 50542288 25647584
20:46:35 2024 8192000000 10987210832 11403096064 1989618112 19.541 100 83 162 0 2066159600 51679264 24862224
20:46:45 5312 8192000000 10992419872 11405701120 1993595584 19.572 100 85 169 1 2070871760 50615024 26661152
20:47:00 4829 8192000000 11009003056 11422068736 2004099232 19.655 100 84 168 1 2086147424 56470912 25577280
20:47:12 2385 8192000000 11019148608 11429654528 2006632752 19.675 100 92 184 0 2093546144 58095504 28817888
20:47:22 2980 8192000000 11010624896 11429826560 2008242624 19.688 100 89 177 0 2094726288 58392224 28091440
20:47:32 3447 8192000000 11004392384 11418042368 1983782672 19.495 99 83 166 1 2068172720 57868176 26521872
20:47:43 2854 8192000000 10994416272 11421515776 1998535968 19.611 100 77 154 1 2083047776 58598176 25913632
20:47:54 4007 8192000000 10997284816 11411025920 1993332704 19.570 100 77 152 1 2072686512 54884688 24469120
20:48:07 1930 8192000000 11000508144 11418447872 1999670176 19.620 100 80 160 1 2080926528 55917776 25338576
20:48:15 4125 8192000000 11005808336 11426504704 2005307088 19.665 100 82 165 1 2089569664 56477280 27785296
20:48:29 3416 8192000000 11017625344 11432284160 2008868896 19.693 100 89 177 1 2096185056 58362896 28953264
20:48:39 4479 8192000000 11016425456 11438469120 2012232512 19.719 100 74 148 0 2096963792 59908656 24822624
20:48:51 6247 8192000000 10998244400 11434123264 1993918576 19.575 99 70 140 0 2077019104 60583184 22517344
20:49:12 1360 8192000000 11013528832 11436843008 2011182016 19.711 100 62 121 0 2087453296 55958704 20312576
20:49:21 1903 8192000000 11032309008 11450900480 2032581248 19.879 100 88 174 0 2115691440 54718928 28391264
20:49:30 2702 8192000000 11024376496 11453972480 2029043440 19.851 100 70 140 0 2106530432 54599792 22887200
20:49:47 7652 8192000000 11011414672 11455447040 2028858304 19.850 100 44 88 1 2094197440 50619104 14720032
20:50:16 5780 8192000000 10995820064 11427065856 1993186480 19.569 99 50 100 0 2062470512 52962272 16321760
20:50:41 15029 8192000000 10997315408 11444404224 2013634544 19.730 100 42 84 0 2083533904 55103584 14795776
20:51:07 19601 8192000000 10980683088 11424628736 1971468064 19.397 98 47 95 3 2041848304 54800768 15579472
20:51:37 5526 8192000000 10983340192 11421396992 1991714048 19.557 100 43 86 4 2059337696 53524912 14098736
20:51:52 14768 8192000000 10981940432 11424944128 1994446608 19.579 100 38 76 0 2066047968 58316672 13284688
20:52:19 12370 8192000000 10965472480 11409227776 1957350688 19.285 99 43 86 0 2037459792 65048608 15060496
20:52:43 17924 8192000000 10959763040 11410182144 1968841344 19.376 100 29 58 0 2036743104 57493168 10408592
20:53:28 23653 8192000000 10948395648 11399151616 1952750464 19.248 99 31 62 0 2028222976 63515856 11956656
20:54:00 9845 8192000000 10941759264 11389284352 1949417952 19.222 100 24 48 2 2018862880 60562144 8882784
20:54:19 16763 8192000000 10941044768 11399245824 1956831536 19.281 100 24 48 2 2027143552 61703136 8608880
20:55:42 12650 8192000000 10933475232 11382796288 1934327392 19.101 99 29 58 0 2002523536 58515168 9680976
20:56:03 15489 8192000000 10923277056 11375464448 1913468992 18.934 98 32 63 2 1982821440 58414544 10937904
20:56:26 35248 8192000000 10862065008 11330105344 1880115488 18.666 97 15 30 0 1919555936 34793344 4647104
20:57:09 108379 8192000000 10869335600 11342737408 1864408704 18.539 96 7 14 0 1883268416 17464944 1394768
20:59:03 93112 8192000000 10918246128 11356164096 1934857152 19.106 99 14 28 1 1950539984 11795872 3886960
21:00:44 12539 8192000000 10921964480 11365826560 1977636768 19.446 100 41 83 1 1998483424 9430000 11416656
21:01:04 30898 8192000000 10903488336 11364823040 1974327456 19.420 100 19 38 0 1989388032 10153936 4906640
21:01:42 86562 8192000000 10904447504 11365302272 1930842592 19.074 98 11 22 1 1947937536 14138576 2956368
21:03:16 47078 8192000000 10902604592 11363491840 1956519936 19.278 99 14 28 1 1970166736 10054064 3592736
21:04:09 66753 8192000000 10930052512 11370819584 1981803328 19.479 100 41 77 1 1999826608 6692000 11331280
21:05:31 59600 8192000000 10916908256 11373293568 1984188528 19.498 100 21 42 2 1997451760 7074160 6189072
21:06:41 1368 8192000000 10946910832 11377983488 1994759856 19.581 100 79 158 0 2029611024 13006704 21844464
21:06:49 37102 8192000000 10944815216 11387908096 1994575600 19.580 100 67 132 4 2023650288 11635664 17439024
21:07:40 26518 8192000000 10931989952 11391447040 1994419440 19.579 100 50 100 1 2023989168 15803664 13766064
21:08:13 23926 8192000000 10938773520 11387195392 1998321712 19.609 100 54 107 2 2023410416 9567552 15521152
21:08:45 34233 8192000000 10909652256 11371941888 1956911744 19.281 98 41 81 2 1976593472 8220144 11461584
21:09:35 35061 8192000000 10904468384 11377864704 1965233104 19.348 99 11 22 0 1975876096 7335616 3307376
21:10:17 43131 8192000000 10901036208 11366264832 1967487760 19.366 99 9 17 0 1981097296 10676720 2932816
21:11:07 37336 8192000000 10898005920 11367936000 1947567040 19.207 98 29 58 1 1970023792 12982336 9474416
21:11:50 41967 8192000000 10911669824 11386839040 1981779936 19.479 100 16 32 2 1996862736 10461776 4621024
21:12:47 58056 8192000000 10924096800 11392045056 1972031024 19.402 99 15 30 1 1988158112 11696688 4430400
21:13:52 52031 8192000000 10928117152 11404144640 1999679888 19.620 100 21 41 0 2021542848 15410064 6452896
21:14:50 45370 8192000000 10941657008 11416977408 2003613664 19.651 100 19 38 0 2029550512 20164192 5772656
21:15:55 69505 8192000000 10926300912 11406618624 1980196672 19.466 99 13 26 0 1994956560 11061296 3698592
21:17:19 34785 8192000000 10910823520 11391221760 1980182800 19.466 99 12 25 0 1996037552 12672464 3182288
21:18:54 76721 8192000000 10882776176 11354099712 1928677616 19.056 97 20 40 1 1947181680 12646864 5857200
21:20:32 2399 8192000000 10910680768 11378761728 1979712000 19.462 100 38 76 0 2003220240 11919456 11588784
21:20:41 45271 8192000000 10922608272 11402805248 1994103200 19.576 100 41 82 4 2024665088 18460832 12101056
21:21:39 45390 8192000000 10902239664 11391479808 1983882336 19.495 100 11 22 3 1999419808 12213136 3324336
21:22:30 51922 8192000000 10911603872 11384582144 1946773168 19.201 98 9 18 0 1959086400 9608976 2704256
21:23:35 43674 8192000000 10883000720 11354976256 1924300624 19.021 97 27 54 3 1946333328 13905872 8126832
21:24:26 34183 8192000000 10852872608 11326730240 1891106640 18.755 97 20 40 1 1903658960 6803424 5748896
21:25:07 45534 8192000000 10903030608 11365302272 1961840448 19.321 100 19 38 1 1976451392 8574688 6036256
21:26:01 14809 8192000000 10895919920 11353931776 1948919984 19.218 99 51 100 0 1970641744 8130848 13590912
21:26:29 14352 8192000000 10889387392 11343495168 1936712416 19.121 99 38 76 0 1957139296 10014128 10412752
21:26:52 17883 8192000000 10908617904 11364151296 1965929376 19.353 100 42 84 0 1990719008 13034704 11754928
21:27:21 54932 8192000000 10892029136 11368501248 1950549152 19.231 99 21 42 0 1971796576 15516672 5730752
21:28:29 51525 8192000000 10891673984 11367591936 1931385200 19.078 98 13 26 0 1945900736 11285312 3230224
21:29:27 72700 8192000000 10890410432 11354550272 1907214816 18.884 97 10 20 0 1917458160 7871888 2371456
21:30:46 33454 8192000000 10897639040 11356422144 1942638560 19.168 99 26 52 2 1957607648 8138624 6830464
21:31:35 51256 8192000000 10908624736 11369250816 1939944112 19.146 98 37 74 1 1963208176 12931424 10332640
21:32:32 72152 8192000000 10869373120 11336220672 1849813136 18.421 94 16 32 0 1865418832 11627968 3977728
21:33:52 107175 8192000000 10863572128 11337412608 1836919232 18.316 94 11 22 0 1857349440 17431568 2998640
21:35:54 55715 8192000000 10835722544 11288059904 1792631936 17.953 93 12 24 0 1804493008 8383568 3477504
21:36:56 10322 8192000000 10841792896 11287986176 1867449808 18.564 98 34 68 0 1884630512 7800496 9380208
21:37:13 29169 8192000000 10864626160 11303739392 1894453472 18.782 99 45 90 1 1917305424 10160240 12691712
21:37:52 112996 8192000000 10847925232 11314270208 1923832736 19.018 100 54 108 0 1947888784 8931840 15124208
21:39:52 77409 8192000000 10863923568 11326722048 1917216720 18.965 99 23 45 1 1936394384 12799280 6378384
21:41:17 28678 8192000000 10857563648 11330744320 1928974496 19.059 100 17 34 0 1945550624 12037168 4538960
21:41:52 27132 8192000000 10850985600 11328667648 1915851840 18.954 99 8 16 0 1925416576 7277008 2287728
21:42:25 24813 8192000000 10809760640 11283693568 1888928848 18.737 98 4 8 0 1903293936 13452816 912272
21:42:56 40982 8192000000 10859044304 11326889984 1914763968 18.945 99 13 26 0 1927716208 9369232 3583008
21:43:49 140685 8192000000 10841549616 11313111040 1870708752 18.590 96 16 32 2 1887072688 11468912 4895024
21:46:15 43492 8192000000 10858878560 11347046400 1934725984 19.105 100 12 24 1 1951534192 13312080 3496128
21:47:46 24381 8192000000 10851972384 11315478528 1898767488 18.816 98 31 62 1 1915261776 7535248 8959040
21:48:19 34245 8192000000 10853733648 11317198848 1921794272 19.001 99 22 44 3 1936670016 8959632 5916112
21:49:00 43877 8192000000 10876812208 11348877312 1924985664 19.027 99 23 46 0 1941763280 10382736 6394880
21:49:51 59927 8192000000 10863615920 11349688320 1926539216 19.039 99 34 69 4 1948949488 12672048 9738224
21:50:57 47524 8192000000 10891442880 11352416256 1919189936 18.980 98 22 44 0 1934107984 8754784 6163264
21:51:59 27611 8192000000 10884489824 11347701760 1945880896 19.194 99 22 43 0 1963182304 11450480 5850928
21:52:34 54763 8192000000 10908966016 11378147328 1971453840 19.397 100 28 56 2 1994974704 15527712 7993152
21:53:35 46483 8192000000 10881822320 11352690688 1950542992 19.231 99 28 56 0 1978204400 18911152 8750256
21:54:27 85764 8192000000 10912557472 11377455104 1952262064 19.244 99 16 32 0 1970044256 13370624 4411568
21:56:01 49476 8192000000 10917151616 11385729024 1980882832 19.472 100 24 48 2 1997857360 10398048 6576480
21:56:57 72119 8192000000 10940024896 11399778304 1998207104 19.609 100 30 60 1 2015056736 8045728 8803904
21:58:19 17090 8192000000 10938342864 11389919232 1982596896 19.485 99 48 95 0 2002737440 7493520 12647024
21:58:42 14999 8192000000 10959015584 11404996608 2003996976 19.654 100 57 114 0 2032323648 12130016 16196656
21:59:08 42634 8192000000 10940925808 11398578176 1961466752 19.318 98 49 98 0 1988640864 13391488 13782624
22:00:12 112372 8192000000 10907678032 11373453312 1947195648 19.204 98 34 70 2 1969373120 11503968 10673504
22:02:44 50288 8192000000 10883857792 11364716544 1938321920 19.133 98 11 22 2 1947517904 6153872 3042112
22:03:47 51890 8192000000 10889493280 11368980480 1953065696 19.251 99 7 14 0 1965613680 10825632 1722352
22:04:45 66028 8192000000 10892126416 11380277248 1977935168 19.448 100 8 17 0 1991483792 11714736 1833888
22:06:00 56064 8192000000 10908230864 11387138048 1985483168 19.508 100 8 16 0 1996303424 8599456 2220800
22:07:14 65177 8192000000 10890139888 11361509376 1874514912 18.621 94 19 38 0 1893618160 13663904 5439344
22:08:26 95698 8192000000 10902190432 11372584960 1910986576 18.915 97 14 28 0 1927268368 12542112 3739680
22:10:43 55607 8192000000 10888246864 11372990464 1941276896 19.157 99 14 28 1 1958680080 12850704 4552480
22:11:56 68975 8192000000 10893953536 11372322816 1916812096 18.961 97 26 52 0 1942011824 17933904 7265824
22:13:12 57357 8192000000 10911764432 11376533504 1950401088 19.230 99 21 42 2 1967059808 11283312 5375408
22:14:19 39615 8192000000 10894558656 11360534528 1958547792 19.294 100 28 56 1 1983692608 17064896 8079920
22:15:06 88450 8192000000 10873439808 11342385152 1880637072 18.670 96 17 34 2 1903790032 18330464 4822496
22:16:43 38033 8192000000 10889531232 11352567808 1910758432 18.913 98 35 69 1 1933404064 12073264 10572368
22:17:27 39018 8192000000 10883766896 11356291072 1899630384 18.823 97 18 36 1 1918766912 13731200 5405328
22:18:20 90292 8192000000 10874860896 11354202112 1878710576 18.655 97 11 23 0 1898535312 17112160 2712576
22:19:56 149865 8192000000 10853326320 11324235776 1886561488 18.718 97 9 18 0 1900006576 11218528 2226560
22:22:32 52371 8192000000 10878292928 11325353984 1890363600 18.749 97 44 88 0 1911332656 8596784 12372272
22:23:35 37594 8192000000 10825448384 11315798016 1910315648 18.909 99 37 74 2 1932049712 11399440 10334624
22:24:29 64097 8192000000 10839940912 11314749440 1877182048 18.642 97 7 14 0 1891048416 11772704 2093664
22:25:39 61993 8192000000 10857902992 11329314816 1888362592 18.733 98 14 28 0 1906015056 13697952 3954512

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:33, from 13-03-2021 22:30:08 to 13-03-2021 22:30:41.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 158 v_add_invoice_to_stock 335544517
except 13 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 13-03-2021 22:30:42 to 13-03-2021 22:30:44.

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          240652
MON$OLDEST_ACTIVE               242909
MON$OLDEST_SNAPSHOT             242909
MON$NEXT_TRANSACTION            242909
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                       2039968
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.33426 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33426 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33426 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33426 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 ---
:28: 
:29: mscs-test-161.budzdorov.ru    Sat Mar 13 22:27:43 2021
:30:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:31: 
:32: 
:33: mscs-test-161.budzdorov.ru    Sat Mar 13 22:28:01 2021
:34:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:35: 
--- end of diff output ---

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

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