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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17526172 kB
MemAvailable 31441288 kB
Buffers 0 kB
Cached 14206016 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-05 01:27:11
DTS_END                         2021-01-05 01:27:11.0620
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/45314
TRN_ID                          241658
ATT_ID                          643
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: 8695.09 26017 1043411
customer order: creation 170.94 350 20513
customer order: refuse 15.29 395 1835
order to supplier: creation 46.41 1237 5569
order to supplier: removal 3.46 102045 415
invoice (draft): creation 45.63 3353 5476
invoice (draft): removal 48.34 864 5801
invoice accept: apply 41.67 19036 5000
invoice accept: cancel 43.33 872 5200
customer reserve: creation 3759.93 192 451192
customer reserve: removal 4232.73 65 507928
realization accept: apply 83.89 202 10067
realization accept: cancel 71.82 114 8618
payment from customer: creation 60.41 132 7249
payment from customer: removal 5.93 84 711
payment to supplier: creation 49.88 139 5986
payment to supplier: removal 2.86 86 343
service: total inventory turnovers 4.83 1111 579
service: total monetary turnovers 6.90 29 828
service: aggregate perf. data 0.81 21538 97
service: refresh index statistics 0.03 368504 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 05-01-2021 01:29:17 to 05-01-2021 01:29:20.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6361
TEST_TIME 2 5611
TEST_TIME 3 4966
TEST_TIME 4 4796
TEST_TIME 5 5018
TEST_TIME 6 6130
TEST_TIME 7 6585
TEST_TIME 8 6591
TEST_TIME 9 6622
TEST_TIME 10 7168
TEST_TIME 11 7157
TEST_TIME 12 7468
TEST_TIME 13 7697
TEST_TIME 14 7857
TEST_TIME 15 8046
TEST_TIME 16 8387
TEST_TIME 17 8710
TEST_TIME 18 8573
TEST_TIME 19 8899
TEST_TIME 20 8959
TEST_TIME 21 9223
TEST_TIME 22 9451
TEST_TIME 23 9724
TEST_TIME 24 9877
TEST_TIME 25 9941
TEST_TIME 26 10162
TEST_TIME 27 11135
TEST_TIME 28 10961
TEST_TIME 29 10727
TEST_TIME 30 10681
TEST_TIME 31 10706
TEST_TIME 32 10669
TEST_TIME 33 10486
TEST_TIME 34 10296
TEST_TIME 35 10318
TEST_TIME 36 10131
TEST_TIME 37 9947
TEST_TIME 38 9786
TEST_TIME 39 9861
TEST_TIME 40 9795
TEST_TIME 41 9621
TEST_TIME 42 9488
TEST_TIME 43 9445
TEST_TIME 44 9360
TEST_TIME 45 9234
TEST_TIME 46 9231
TEST_TIME 47 9336
TEST_TIME 48 9281
TEST_TIME 49 9155
TEST_TIME 50 9188
TEST_TIME 51 9092
TEST_TIME 52 9090
TEST_TIME 53 9040
TEST_TIME 54 9027
TEST_TIME 55 9052
TEST_TIME 56 8989
TEST_TIME 57 9018
TEST_TIME 58 9017
TEST_TIME 59 9009
TEST_TIME 60 9078
TEST_TIME 61 9087
TEST_TIME 62 9131
TEST_TIME 63 9157
TEST_TIME 64 9148
TEST_TIME 65 9108
TEST_TIME 66 9164
TEST_TIME 67 9078
TEST_TIME 68 9053
TEST_TIME 69 8967
TEST_TIME 70 8959
TEST_TIME 71 8953
TEST_TIME 72 8891
TEST_TIME 73 8902
TEST_TIME 74 8819
TEST_TIME 75 8755
TEST_TIME 76 8765
TEST_TIME 77 8761
TEST_TIME 78 8898
TEST_TIME 79 8863
TEST_TIME 80 8914
TEST_TIME 81 8937
TEST_TIME 82 9005
TEST_TIME 83 8996
TEST_TIME 84 9012
TEST_TIME 85 8978
TEST_TIME 86 9054
TEST_TIME 87 9075
TEST_TIME 88 9066
TEST_TIME 89 9060
TEST_TIME 90 9061
TEST_TIME 91 9022
TEST_TIME 92 8970
TEST_TIME 93 8959
TEST_TIME 94 8929
TEST_TIME 95 8881
TEST_TIME 96 8860
TEST_TIME 97 8883
TEST_TIME 98 8881
TEST_TIME 99 8862
TEST_TIME 100 8884
TEST_TIME 101 8957
TEST_TIME 102 9013
TEST_TIME 103 9011
TEST_TIME 104 8990
TEST_TIME 105 9053
TEST_TIME 106 9040
TEST_TIME 107 9025
TEST_TIME 108 9047
TEST_TIME 109 9018
TEST_TIME 110 9012
TEST_TIME 111 8982
TEST_TIME 112 8960
TEST_TIME 113 8942
TEST_TIME 114 8897
TEST_TIME 115 8877
TEST_TIME 116 8852
TEST_TIME 117 8837
TEST_TIME 118 8832
TEST_TIME 119 8769
TEST_TIME 120 8698

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 05-01-2021 01:29:21 to 05-01-2021 01:29:24.

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 1460986 1460986 0 0.00 0 16703 7 0 0
doc_list_biud 1460985 1460985 0 0.00 0 56787 29 0 0
sp_add_invoice_to_stock 5148 5000 148 2.87 30 196691 19037 0 148
sp_cancel_adding_invoice 5200 5200 0 0.00 4 44434 873 0 0
sp_cancel_client_order 1835 1835 0 0.00 4 18027 396 0 0
sp_cancel_customer_reserve 507928 507928 0 0.00 1 56788 65 0 0
sp_cancel_pay_from_customer 711 711 0 0.00 3 7515 84 0 0
sp_cancel_pay_to_supplier 343 343 0 0.00 2 3116 87 0 0
sp_cancel_supplier_invoice 5811 5801 10 0.17 2 17715 865 0 10
sp_cancel_supplier_order 415 415 0 0.00 4 1102268 102046 0 0
sp_cancel_write_off 8618 8618 0 0.00 1 16546 114 0 0
sp_client_order 20513 20513 0 0.00 3 21095 351 0 0
sp_customer_reserve 451192 451192 0 0.00 0 86489 192 0 0
sp_fill_shopping_cart 31551 31551 0 0.00 1 14407 43 0 0
sp_fill_shopping_cart_clo_res 451185 451185 0 0.00 0 29363 15 0 0
sp_get_clo_for_invoice 4992 4992 0 0.00 0 34342 360 0 0
sp_kill_cost_storno 14872 14872 0 0.00 0 9781 60 0 0
sp_kill_qstorno_ret_qs2qd 1030690 1030690 0 0.00 0 56784 35 0 0
sp_kill_qty_storno 544856 544856 0 0.00 0 56787 77 0 0
sp_lock_selected_doc 20817 20817 0 0.00 0 8916 5 0 0
sp_make_cost_storno 28294 28294 0 0.00 0 16697 65 0 0
sp_multiply_rows_for_pdistr 28294 28294 0 0.00 0 10134 31 0 0
sp_multiply_rows_for_qdistr 20513 20513 0 0.00 0 20074 153 0 0
sp_pay_from_customer 7249 7249 0 0.00 4 13979 133 0 0
sp_pay_to_supplier 5986 5986 0 0.00 5 13985 140 0 0
sp_payment_common 13235 13235 0 0.00 1 10682 36 0 0
sp_qd_handle_on_cancel_clo 1835 1835 0 0.00 0 10927 356 0 0
sp_qd_handle_on_invoice_upd_sts 10192 10192 0 0.00 0 32880 378 0 0
sp_qd_handle_on_reserve_upd_sts 10067 10067 0 0.00 0 20691 61 0 0
sp_reserve_write_off 10067 10067 0 0.00 6 21172 202 0 0
sp_supplier_invoice 5476 5476 0 0.00 7 73331 3354 0 0
sp_supplier_order 5569 5569 0 0.00 5 25907 1238 0 0
srv_aggregate_perf_data 97 97 0 0.00 3053 173620 21539 0 0
srv_fill_mon_cache_memory 169 169 0 0.00 1574 157129 31157 0 0
srv_find_qd_qs_mism 995782 995782 0 0.00 0 10046 6 0 0
srv_make_invnt_saldo 579 579 0 0.00 37 76399 1112 0 0
srv_make_money_saldo 828 828 0 0.00 1 3057 29 0 0
srv_recalc_idx_stat 4 4 0 0.00 144477 613762 368505 0 0
t$perf-abend:sp_add_invoice_to_stock 148 148 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 5000 5000 0 0.00 0 32195 178 0 0
t$perf-norm:sp_cancel_adding_invoice 395 395 0 0.00 1 22965 157 0 0
t$perf-norm:sp_cancel_client_order 1835 1835 0 0.00 0 23346 28 0 0
t$perf-norm:sp_cancel_customer_reserve 669 669 0 0.00 0 983 10 0 0
t$perf-norm:sp_cancel_pay_from_customer 711 711 0 0.00 0 1771 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 343 343 0 0.00 0 218 4 0 0
t$perf-norm:sp_cancel_supplier_invoice 397 397 0 0.00 0 3310 22 0 0
t$perf-norm:sp_cancel_supplier_order 415 415 0 0.00 0 37538 1672 0 0
t$perf-norm:sp_cancel_write_off 993 993 0 0.00 0 1294 8 0 0
t$perf-norm:sp_client_order 20513 20513 0 0.00 0 12074 19 0 0
t$perf-norm:sp_customer_reserve 1055 1055 0 0.00 0 12186 21 0 0
t$perf-norm:sp_pay_from_customer 7249 7249 0 0.00 0 5476 9 0 0
t$perf-norm:sp_pay_to_supplier 5986 5986 0 0.00 0 11703 10 0 0
t$perf-norm:sp_reserve_write_off 10067 10067 0 0.00 0 6548 13 0 0
t$perf-norm:sp_supplier_invoice 5476 5476 0 0.00 0 21264 24 0 0
t$perf-norm:sp_supplier_order 5569 5569 0 0.00 0 21209 23 0 0
t$perf-norm:srv_aggregate_perf_data 97 97 0 0.00 0 330 9 0 0
t$perf-norm:srv_fill_mon_cache_memory 169 169 0 0.00 0 3631 25 0 0
t$perf-norm:srv_make_invnt_saldo 579 579 0 0.00 0 663 16 0 0
t$perf-norm:srv_make_money_saldo 828 828 0 0.00 0 2294 19 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 11 5 0 0
v_add_invoice_to_stock 10279 9984 295 2.86 0 16222 23 0 295
v_all_customers 37208 37208 0 0.00 0 51 1 0 0
v_all_suppliers 30658 30658 0 0.00 0 21 1 0 0
v_all_wares 41026 41026 0 0.00 0 22 1 0 0
v_cancel_adding_invoice 790 790 0 0.00 0 730 8 0 0
v_cancel_client_order 3670 3670 0 0.00 0 15784 13 0 0
v_cancel_customer_prepayment 1422 1422 0 0.00 0 7505 14 0 0
v_cancel_customer_reserve 1338 1338 0 0.00 0 4337 11 0 0
v_cancel_payment_to_supplier 686 686 0 0.00 0 1883 9 0 0
v_cancel_supplier_invoice 814 794 20 2.45 0 1642 21 0 20
v_cancel_supplier_order 830 830 0 0.00 0 6611 23 0 0
v_cancel_write_off 1986 1986 0 0.00 0 1961 16 0 0
v_max_id_clo_ord 5568 5568 0 0.00 0 2665 2 0 0
v_max_id_clo_res 1055 1055 0 0.00 0 2416 12 0 0
v_max_id_ord_sup 5470 5470 0 0.00 0 8928 5 0 0
v_max_non_paid_invoice 1695 1695 0 0.00 0 1350 5 0 0
v_max_non_paid_realizn 4000 4000 0 0.00 0 1881 4 0 0
v_min_id_clo_ord 5568 5568 0 0.00 0 11956 12 0 0
v_min_id_clo_res 1055 1055 0 0.00 0 3764 11 0 0
v_min_id_ord_sup 5470 5470 0 0.00 0 4270 5 0 0
v_min_non_paid_invoice 5986 5986 0 0.00 0 10047 20 0 0
v_min_non_paid_realizn 7249 7249 0 0.00 0 10674 28 0 0
v_our_firm 10316 10316 0 0.00 0 16 1 0 0
v_reserve_write_off 20134 20134 0 0.00 0 13382 8 0 0
x_lock_depdocs_on_canc_invoice 10604 10604 0 0.00 0 25585 135 0 0
x_lock_depdocs_on_canc_sup_ord 415 415 0 0.00 0 10793 365 0 0
x_make_qstorno_1000_1200 5569 5569 0 0.00 1 24186 1147 0 0
x_make_qstorno_1200_2000 5476 5476 0 0.00 2 73298 3205 0 0
x_make_qstorno_2100_3300 451192 451192 0 0.00 0 86487 174 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 05-01-2021 01:29:25 to 05-01-2021 01:29:29.

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:14 3 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
22:57:21 6428 8192000000 10083880816 10376921088 817435536 9.073 66 48 97 0 835473744 2230544 15807664
22:57:35 22249 8192000000 10318664208 10631983104 1355305264 14.195 100 82 164 0 1385931568 4002400 26623904
22:58:07 29576 8192000000 10353255616 10676342784 1403351568 14.625 100 85 170 0 1437524064 6055072 28117424
22:58:48 28512 8192000000 10393028304 10724360192 1446746032 15.009 100 91 181 1 1483541248 6955120 29840096
22:59:27 17822 8192000000 10411374656 10743009280 1466039008 15.179 100 87 174 0 1502040752 7672880 28328864
22:59:55 10745 8192000000 10420196464 10756169728 1483264864 15.330 100 86 172 0 1518866736 7988080 27613792
23:00:14 14910 8192000000 10440121008 10772996096 1493837072 15.422 100 84 168 0 1529515216 8470848 27207296
23:00:37 16676 8192000000 10459373616 10797060096 1509097264 15.555 100 86 172 0 1545576768 8740496 27739008
23:01:02 17549 8192000000 10476628368 10821169152 1529919328 15.736 100 84 167 1 1565977792 9239296 26819168
23:01:37 19267 8192000000 10510252992 10860544000 1559598048 15.993 100 78 156 0 1593465920 9452368 24415504
23:02:09 10881 8192000000 10540115216 10892009472 1594971936 16.296 100 76 150 3 1626904016 9043184 22888896
23:02:27 12601 8192000000 10559499232 10915856384 1613568000 16.455 100 77 154 1 1647447824 9684736 24195088
23:02:47 11828 8192000000 10584594272 10942029824 1634128960 16.630 100 83 164 2 1669105968 10561904 24415104
23:03:08 14682 8192000000 10595464800 10964373504 1655762720 16.813 100 72 144 0 1688404288 11039152 21602416
23:03:31 11010 8192000000 10618318880 10987388928 1685126784 17.060 100 80 160 1 1719490976 11340944 23023248
23:03:51 10073 8192000000 10638645776 11007225856 1699605248 17.182 100 81 161 2 1735511904 12249424 23657232
23:04:08 9399 8192000000 10646867456 11022151680 1710212672 17.271 100 80 160 0 1746693072 13181312 23299088
23:04:24 7787 8192000000 10664497696 11035475968 1718100880 17.336 100 85 168 1 1755606064 13198784 24306400
23:04:40 6445 8192000000 10680953120 11057811456 1738187376 17.504 100 84 168 0 1776777520 13935760 24654384
23:04:53 5820 8192000000 10694002416 11070566400 1751921696 17.618 100 85 169 3 1789409760 13021856 24466208
23:05:08 6644 8192000000 10709906320 11087081472 1767852080 17.749 100 90 181 0 1805696496 12635152 25209264
23:05:22 4989 8192000000 10714343232 11092656128 1771103872 17.776 100 76 151 1 1805592560 13106352 21382336
23:05:35 5388 8192000000 10726317664 11109257216 1780755728 17.856 100 84 163 2 1816493472 13099776 22637968
23:05:47 4600 8192000000 10735157344 11114938368 1793785328 17.963 100 90 180 2 1833492752 13939264 25768160
23:05:58 3065 8192000000 10742267024 11125387264 1799347520 18.009 100 87 172 0 1836432368 13270528 23814320
23:06:09 2602 8192000000 10742896384 11129978880 1808594576 18.084 100 77 154 2 1843162544 12927936 21640032
23:06:18 2722 8192000000 10762935808 11148664832 1821134112 18.187 100 88 175 0 1858758320 13562880 24061328
23:06:28 2917 8192000000 10768186640 11151642624 1825726160 18.224 100 89 178 1 1863482240 13188128 24567952
23:06:38 8018 8192000000 10767982592 11155992576 1828790864 18.249 100 81 160 1 1864702128 13994304 21916960
23:06:53 5813 8192000000 10769082272 11163430912 1834182720 18.293 100 83 167 0 1870994784 13416576 23395488
23:07:05 2536 8192000000 10783811120 11174891520 1846231728 18.392 100 90 181 1 1885124544 13290000 25602816
23:07:14 2599 8192000000 10789489680 11180077056 1851302096 18.433 100 86 171 2 1887285872 12492640 23491136
23:07:24 2382 8192000000 10795810544 11185283072 1853989696 18.455 100 93 185 0 1893323920 12880784 26453440
23:07:32 1670 8192000000 10793793136 11187744768 1856243792 18.473 100 86 172 0 1893617088 12690208 24683088
23:07:40 2164 8192000000 10797878448 11191492608 1860193968 18.505 100 86 172 1 1897886608 12584032 25108608
23:07:49 1804 8192000000 10812104416 11202527232 1866689296 18.557 100 90 179 2 1905104464 13423376 24991792
23:07:57 2216 8192000000 10813882080 11204694016 1873960832 18.616 100 89 180 1 1911483536 13308288 24214416
23:08:05 2080 8192000000 10818609152 11208773632 1871428032 18.596 100 95 191 3 1912866320 14041136 27397152
23:08:14 1566 8192000000 10819556720 11208437760 1873693024 18.614 100 97 193 1 1915987376 14647216 27647136
23:08:22 1852 8192000000 10816353664 11207053312 1872210960 18.602 100 91 182 5 1911708800 13552240 25945600
23:08:30 1710 8192000000 10814729152 11210764288 1877628288 18.646 100 85 172 0 1914028192 12230864 24169040
23:08:38 13261 8192000000 10810324848 11220406272 1878112912 18.650 100 68 135 1 1908996640 12293488 18590240
23:08:58 16288 8192000000 10821386880 11219410944 1882976240 18.689 100 85 170 0 1918861616 12077600 23807776
23:09:21 22823 8192000000 10794251968 11207278592 1884640816 18.703 100 60 120 1 1911309216 8566688 18101712
23:09:51 20347 8192000000 10802629296 11217412096 1881278288 18.675 100 50 100 1 1904050384 8759056 14013040
23:10:25 7574 8192000000 10791561040 11215286272 1879474576 18.661 100 30 61 1 1894825024 5337248 10013200
23:10:42 4638 8192000000 10798945488 11219374080 1883651808 18.695 100 41 82 1 1904426224 9678544 11095872
23:10:53 5929 8192000000 10798781072 11223715840 1883568688 18.694 100 35 70 2 1900750944 7366432 9815824
23:11:08 7060 8192000000 10802517856 11228651520 1888885504 18.737 100 31 62 2 1904492272 6304272 9302496
23:11:22 8565 8192000000 10799515216 11229192192 1887235968 18.723 100 21 42 1 1899733552 6961488 5536096
23:11:38 9477 8192000000 10787213872 11227910144 1890006192 18.746 100 32 64 1 1906719216 7600000 9113024
23:11:54 6630 8192000000 10805225152 11234828288 1891922480 18.761 100 20 40 2 1904011136 6079072 6009584
23:12:10 13299 8192000000 10809662112 11236999168 1891093952 18.755 100 16 32 0 1901667840 6079936 4493952
23:12:30 13154 8192000000 10798124784 11234828288 1894743376 18.784 100 19 38 2 1906188288 6048000 5396912
23:12:51 5916 8192000000 10797543008 11236470784 1896877744 18.801 100 25 46 4 1910049232 5967504 7203984
23:13:08 9378 8192000000 10810598912 11244158976 1896715456 18.800 100 22 44 1 1909278528 6207040 6356032
23:13:28 10337 8192000000 10799922720 11241988096 1896747136 18.800 100 16 32 0 1912103344 11092432 4263776
23:13:44 9595 8192000000 10807317728 11244920832 1900920768 18.834 100 24 48 3 1914204352 6393680 6889904
23:14:00 6141 8192000000 10819638416 11250393088 1902186384 18.844 100 22 44 2 1918930240 10326544 6417312
23:14:18 7141 8192000000 10814852496 11249356800 1908288304 18.893 100 40 82 1 1927208192 6005280 12914608
23:14:33 54724 8192000000 10849704992 11260448768 1911268400 18.917 100 63 127 1 1936116736 5228384 19619952
23:15:34 5632 8192000000 10816409296 11250171904 1886819248 18.720 99 32 64 1 1905141488 9269584 9052656
23:15:47 9052 8192000000 10806118976 11244462080 1901173344 18.836 100 22 42 0 1913210320 6036896 6000080
23:16:02 8774 8192000000 10805774352 11243261952 1894551536 18.782 100 19 36 1 1904792512 5249712 4991264
23:16:21 6227 8192000000 10805064176 11244138496 1891218848 18.756 100 19 38 1 1906686224 10286736 5180640
23:16:38 10617 8192000000 10793977552 11231789056 1855002000 18.463 98 31 62 1 1870216736 6650736 8564000
23:16:55 6332 8192000000 10805363808 11228463104 1866421296 18.555 99 35 70 2 1883342688 6779728 10141664
23:17:13 7330 8192000000 10778309808 11213619200 1844312320 18.376 98 22 44 0 1857480800 6086080 7082400
23:17:27 8972 8192000000 10779623024 11208728576 1850965056 18.430 99 18 36 0 1862853792 6294480 5594256
23:17:43 5333 8192000000 10790921744 11217952768 1874953696 18.624 100 39 77 2 1892463264 6071632 11437936
23:17:55 9555 8192000000 10769554912 11191881728 1808451552 18.083 97 19 38 1 1819654384 5807024 5395808
23:18:14 8718 8192000000 10762322416 11195703296 1840201024 18.342 99 14 26 2 1848632656 5111488 3320144
23:18:32 12522 8192000000 10755563264 11182776320 1829217344 18.253 99 13 26 0 1838064368 5117808 3729216
23:18:51 6892 8192000000 10742212816 11172331520 1805884288 18.062 98 21 40 2 1817540656 5484480 6171888
23:19:07 46471 8192000000 10720061952 11144294400 1740697024 17.524 95 16 32 1 1750224880 4983984 4543872
23:19:59 30777 8192000000 10686876048 11105366016 1620752368 16.516 89 21 41 0 1630860432 4316960 5791104
23:20:40 6071 8192000000 10726826080 11147804672 1799419552 18.009 99 35 71 1 1816461680 7594128 9448000
23:20:53 4780 8192000000 10734475488 11147370496 1812769616 18.119 100 43 86 1 1833348720 8266240 12312864
23:21:06 5834 8192000000 10703593872 11116494848 1751917904 17.617 98 23 46 0 1764388976 5795520 6675552
23:21:21 5680 8192000000 10693541984 11097825280 1739392752 17.514 98 27 54 1 1752500176 5155712 7951712
23:21:35 9428 8192000000 10702846176 11115524096 1754205920 17.636 98 23 46 1 1766366608 5672848 6487840
23:21:55 10572 8192000000 10718274480 11132248064 1779080816 17.842 99 26 52 1 1793136496 6297776 7757904
23:22:12 12115 8192000000 10713628848 11130359808 1769776768 17.765 98 23 46 1 1781861760 5038128 7046864
23:22:32 8096 8192000000 10736350880 11156688896 1818436400 18.165 100 31 61 1 1833082704 5594096 9052208
23:22:48 15665 8192000000 10727552272 11148713984 1794766800 17.971 99 22 44 2 1806663104 5142736 6753568
23:23:13 19431 8192000000 10743028848 11174199296 1832180864 18.277 100 30 60 0 1847140640 5191712 9768064
23:23:42 14739 8192000000 10770626416 11190206464 1848529760 18.410 100 27 54 1 1861844432 5987632 7327040
23:24:07 46838 8192000000 10792374832 11200118784 1860897008 18.511 100 45 90 2 1879482080 4917968 13667104
23:25:01 15175 8192000000 10774583744 11206426624 1864733328 18.542 100 33 67 3 1881681744 7731632 9216784
23:25:23 10623 8192000000 10798935840 11214811136 1870102576 18.585 100 44 89 1 1888145856 5503104 12540176
23:25:40 7690 8192000000 10774493520 11212877824 1870517840 18.588 100 34 65 4 1888268368 8356336 9394192
23:25:55 10084 8192000000 10791456960 11215380480 1872058672 18.601 100 31 62 2 1886942352 5614608 9269072
23:26:12 4562 8192000000 10792499104 11219443712 1874951824 18.624 100 29 58 2 1891325760 6567152 9806784
23:26:24 5507 8192000000 10801075632 11231129600 1880609008 18.670 100 23 46 0 1893077536 5783104 6685424
23:26:38 9299 8192000000 10802919680 11231866880 1883918976 18.697 100 25 50 1 1896689360 5002464 7767920
23:26:59 9700 8192000000 10802766112 11236700160 1891660704 18.759 100 14 28 0 1900405488 5090064 3654720
23:27:15 7139 8192000000 10842647824 11264458752 1911941008 18.922 100 41 81 2 1932573408 9324464 11307936
23:27:34 10967 8192000000 10859105616 11276894208 1924699616 19.024 100 51 100 3 1944953536 6490992 13762928
23:27:56 10032 8192000000 10864759344 11285188608 1930004192 19.067 100 55 110 2 1953153856 8231952 14917712
23:28:13 16399 8192000000 10873485808 11294605312 1937394560 19.126 100 55 109 1 1962116768 9789344 14932864
23:28:47 18999 8192000000 10878151392 11302195200 1942462400 19.166 100 41 82 0 1962965872 8857616 11645856
23:29:13 23944 8192000000 10880989504 11311722496 1956738368 19.280 100 49 98 0 1980623824 9622528 14262928
23:29:56 27242 8192000000 10898786656 11321217024 1958119424 19.291 100 47 95 0 1983433456 11093888 14220144
23:30:30 99233 8192000000 10903880832 11347984384 1966633760 19.359 100 40 80 0 1991869600 12935392 12300448
23:32:21 16647 8192000000 10902079296 11343233024 1974203120 19.419 100 39 78 1 1999818960 14281936 11333904
23:32:48 29656 8192000000 10910428016 11340517376 1953876576 19.257 99 33 66 1 1980453120 17290416 9286128
23:33:34 2306 8192000000 10931388208 11354615808 1980539616 19.469 100 69 139 4 2019773760 18678288 20555856
23:33:44 2758 8192000000 10940413616 11358830592 1982372240 19.483 100 65 130 1 2023925008 22112256 19440512
23:33:54 3248 8192000000 10941318400 11363160064 1986489712 19.516 100 69 138 0 2025226048 18683856 20052480
23:34:06 15122 8192000000 10940643440 11357655040 1982659984 19.486 100 67 134 0 2022633184 20166272 19806928
23:34:28 2597 8192000000 10947359872 11364380672 1988478048 19.532 100 75 150 2 2030240976 19923984 21838944
23:34:40 2368 8192000000 10949909488 11367243776 1996034064 19.591 100 83 166 0 2042690720 22405824 24250832
23:34:48 5637 8192000000 10943689248 11369271296 1995257616 19.585 100 72 142 2 2035676512 20227936 20190960
23:35:11 6078 8192000000 10948935168 11366195200 1975324224 19.428 99 76 150 2 2017448304 20162336 21961744
23:35:25 4545 8192000000 10947990448 11366764544 1991071984 19.552 100 76 152 1 2033308016 20584240 21651792
23:35:39 2092 8192000000 10950969808 11369705472 1991395392 19.555 100 68 136 2 2032603056 20978464 20229200
23:35:49 8895 8192000000 10956117360 11375337472 1996759312 19.597 100 66 131 0 2038105696 21063744 20282640
23:36:05 5141 8192000000 10960503200 11374059520 1996171344 19.593 100 78 154 2 2040842160 20747696 23923120
23:36:17 5430 8192000000 10952603408 11376300032 1983666992 19.494 99 67 134 0 2024963280 21576928 19719360
23:36:29 2429 8192000000 10959512848 11384360960 2003783936 19.653 100 75 150 0 2048961568 22785760 22391872
23:36:38 2115 8192000000 10965857216 11389698048 2007100656 19.679 100 75 149 1 2052489504 22750368 22638480
23:36:57 4604 8192000000 10966780992 11397410816 2011903616 19.716 100 63 126 1 2056495136 24933072 19658448
23:37:11 12342 8192000000 10958696544 11396218880 2010652144 19.707 100 58 116 2 2052456096 24273728 17530224
23:37:31 9499 8192000000 10965286720 11400269824 2014104912 19.734 100 53 105 1 2051911952 21301024 16506016
23:37:50 4737 8192000000 10963831856 11383709696 2000923200 19.630 99 72 144 1 2044031392 20536464 22571728
23:38:01 6586 8192000000 10961072576 11395170304 1996375552 19.594 99 64 126 3 2037881808 21704240 19802016
23:38:17 5934 8192000000 10957924128 11397586944 2009256656 19.696 100 56 109 0 2048220480 22179456 16784368
23:38:29 6318 8192000000 10963532512 11395137536 1970528288 19.390 98 61 117 3 2010169632 22140704 17500640
23:38:44 4678 8192000000 10967826320 11391987712 2005170160 19.663 100 80 159 2 2054301728 25046064 24085504
23:38:58 4328 8192000000 10977262656 11396599808 2000833120 19.629 99 90 180 1 2054412064 27058208 26520736
23:39:12 4626 8192000000 10977097504 11399168000 2006770560 19.676 100 82 161 0 2061020800 30371472 23878768
23:39:26 2513 8192000000 10974563792 11400826880 2008263200 19.688 100 69 132 7 2060054512 30746688 21044624
23:39:40 1573 8192000000 10985224816 11402092544 2011185680 19.711 100 85 168 3 2069483904 31362624 26935600
23:39:48 3206 8192000000 10991951184 11411554304 2012402240 19.720 100 88 174 1 2077438752 38360176 26676336
23:40:00 1899 8192000000 10984528784 11398275072 2002683376 19.644 100 89 176 3 2061009376 31521104 26804896
23:40:10 8780 8192000000 10953767712 11382943744 1991482272 19.556 100 74 146 1 2045478272 31431216 22564784
23:40:27 4286 8192000000 10949163568 11380178944 1974316928 19.420 99 60 119 0 2023819408 31216128 18286352
23:40:40 6356 8192000000 10942184016 11369693184 1947454672 19.206 98 60 120 1 2000518592 34171696 18892224
23:40:53 3814 8192000000 10945534304 11373174784 1984400464 19.500 100 67 132 1 2035678832 30660144 20618224
23:41:07 6411 8192000000 10929883792 11358121984 1967257344 19.364 99 64 128 0 2019675488 32210880 20207264
23:41:22 3597 8192000000 10953736784 11380338688 1985243760 19.506 100 74 148 2 2042424976 33747440 23433776
23:41:34 10491 8192000000 10952397344 11386527744 1987399040 19.523 100 55 110 1 2035155184 30178464 17577680
23:41:54 5928 8192000000 10965538848 11396403200 1989924784 19.543 100 62 124 2 2043726496 33855088 19946624
23:42:16 2493 8192000000 10957678256 11391688704 1995364240 19.586 100 69 140 1 2047745888 30995744 21385904
23:42:26 8658 8192000000 10961228480 11381723136 1982516288 19.485 100 66 132 1 2034391072 31218560 20656224
23:42:42 4250 8192000000 10938110256 11363823616 1955941968 19.274 99 68 136 1 2008533952 31802000 20789984
23:42:54 5371 8192000000 10961027184 11379314688 1970833872 19.392 99 81 161 1 2028833952 32856240 25143840
23:43:08 3664 8192000000 10967221040 11387338752 1993050848 19.568 100 78 154 1 2048693536 32366544 23276144
23:43:19 3394 8192000000 10982891680 11396788224 1999423664 19.618 100 85 171 2 2059246080 33857408 25965008
23:43:29 2678 8192000000 10970828224 11382239232 1988962032 19.536 100 89 177 0 2049146656 33251520 26933104
23:43:39 2016 8192000000 10952375568 11367030784 1971697136 19.399 99 89 177 0 2035080880 35926944 27456800
23:43:49 1638 8192000000 10971969632 11384709120 1988169040 19.529 100 94 188 0 2054165072 37402368 28593664
23:43:57 3658 8192000000 10962685072 11381497856 1984358064 19.499 100 77 153 1 2040824864 33251024 23215776
23:44:08 1735 8192000000 10968486880 11387002880 1974832016 19.424 99 77 154 1 2032569312 33387040 24350256
23:44:17 3321 8192000000 10938091824 11359371264 1945548624 19.191 98 71 143 0 2001527200 33168176 22810400
23:44:30 1930 8192000000 10966427696 11383492608 1988160176 19.529 100 81 161 1 2049123632 34530800 26432656
23:44:41 5050 8192000000 10957929712 11394764800 1990717600 19.549 100 66 132 1 2045904896 34615264 20572032
23:44:58 5590 8192000000 10908455984 11343966208 1937558816 19.127 98 39 77 1 1981950592 31411552 12980224
23:45:12 8718 8192000000 10930580208 11362234368 1937316208 19.125 98 46 92 1 1983768736 31797728 14654800
23:45:27 2936 8192000000 10952172048 11368824832 1957237984 19.284 99 85 166 1 2018683312 35717024 25728304
23:45:37 3920 8192000000 10962632944 11384913920 1981799136 19.479 100 73 144 0 2042704432 38413328 22491968
23:45:53 3207 8192000000 10970900208 11384975360 1971520112 19.398 99 82 164 3 2039964496 42864016 25580368
23:46:03 2779 8192000000 10979882592 11396780032 1988949856 19.535 100 82 164 0 2058379424 43738960 25690608
23:46:15 1947 8192000000 10970369024 11382239232 1960409344 19.309 99 87 172 1 2031607088 43686352 27511392
23:46:26 2392 8192000000 10979538816 11393040384 1986181728 19.514 100 85 168 0 2058443856 45505056 26757072
23:46:37 4535 8192000000 10970730784 11395125248 1982332176 19.483 100 77 154 2 2054058064 47355008 24370880
23:46:51 8227 8192000000 10955686896 11395239936 1983647536 19.494 100 49 98 1 2044398672 44365344 16385792
23:47:09 5927 8192000000 10972969184 11402821632 1990279680 19.546 100 54 107 0 2050606960 42001088 18326192
23:47:25 7237 8192000000 10975731424 11409293312 1995158512 19.585 100 58 117 0 2057760752 44026240 18576000
23:47:44 5292 8192000000 10977688080 11414392832 1997261696 19.601 100 56 110 1 2060527664 45405920 17860048
23:47:58 7254 8192000000 10982683104 11412070400 1992942448 19.567 100 51 103 1 2054422608 44590416 16889744
23:48:18 3259 8192000000 11005282864 11419578368 2000822800 19.629 100 82 158 2 2073674544 47706352 25145392
23:48:28 5255 8192000000 10998243056 11426295808 2008478576 19.690 100 77 153 2 2083961120 51294208 24188336
23:48:44 3989 8192000000 10983229024 11419234304 1988381616 19.531 100 55 110 1 2063294144 56536640 18375888
23:48:58 10495 8192000000 10941598480 11382468608 1964871696 19.345 99 32 64 0 2023394224 46641936 11880592
23:49:32 3497 8192000000 10965197712 11396423680 1979471840 19.461 100 60 119 4 2044836608 45062960 20301808
23:49:56 3538 8192000000 10941262240 11373912064 1953254272 19.252 99 53 107 2 2011187072 41184496 16748304
23:50:10 11548 8192000000 10931980448 11381972992 1967951904 19.369 100 35 69 1 2022336192 42999984 11384304
23:50:29 22221 8192000000 10940333664 11393273856 1969816464 19.384 100 29 58 2 2023653664 43269312 10567888
23:50:58 22135 8192000000 10929792112 11384070144 1932294768 19.085 98 34 68 3 1987036016 44035568 10705680
23:51:27 24032 8192000000 10920330624 11376963584 1957871488 19.289 100 25 50 1 2008352272 41811904 8668880
23:52:01 25523 8192000000 10923994032 11373981696 1940096560 19.148 99 25 50 1 1993576992 43850784 9629648
23:52:43 25959 8192000000 10903233184 11369062400 1943965792 19.178 100 27 52 1 2000543904 46724640 9853472
23:53:36 29625 8192000000 10925499968 11381923840 1955556208 19.271 100 28 56 1 2010930320 45914496 9459616
23:54:31 20813 8192000000 10897954064 11362439168 1956602592 19.279 100 13 27 1 1989456288 28705376 4148320
23:55:03 42120 8192000000 10906313888 11349942272 1943563024 19.175 99 31 63 0 1962279680 9363712 9352944
23:55:57 30187 8192000000 10883488320 11347640320 1940363536 19.150 99 27 54 3 1960565984 12393328 7809120
23:56:46 33052 8192000000 10888521824 11352629248 1956091312 19.275 100 20 40 0 1979729264 17332400 6305552
23:57:38 33674 8192000000 10894837376 11361120256 1960189168 19.308 100 21 42 0 1980854816 14149408 6516240
23:58:18 38986 8192000000 10832934640 11295084544 1882300912 18.684 96 9 18 1 1902664272 17630800 2732560
23:59:03 28362 8192000000 10859116416 11336450048 1931177952 19.076 100 9 18 1 1947803584 14213744 2411888
23:59:38 64782 8192000000 10862662640 11315064832 1892269392 18.764 97 16 32 1 1904026688 7831072 3926224
00:00:50 152704 8192000000 10871035824 11334631424 1895487456 18.790 97 14 29 0 1910576784 11323008 3766320
00:04:00 60307 8192000000 10893521312 11330011136 1931514512 19.079 99 23 46 0 1948641088 9980352 7146224
00:05:18 97259 8192000000 10901349744 11357315072 1938564368 19.135 99 34 68 3 1957845872 10087936 9193568
00:07:05 81684 8192000000 10872195952 11335577600 1907379776 18.886 97 21 42 2 1922617728 9294672 5943280
00:08:35 30823 8192000000 10884195216 11341410304 1946984304 19.202 99 30 60 0 1963690976 8291824 8414848
00:09:12 11072 8192000000 10887903088 11350257664 1965165232 19.347 100 21 42 1 1981808576 10686512 5956832
00:09:31 12086 8192000000 10899901856 11352117248 1966456960 19.357 100 23 46 0 1982978816 10152880 6368976
00:10:02 8862 8192000000 10887742832 11343450112 1947375328 19.206 99 38 76 0 1969608480 11650144 10583008
00:10:18 29357 8192000000 10889626928 11352260608 1944667744 19.184 99 19 38 1 1962925120 12453968 5803408
00:11:04 43566 8192000000 10911412704 11364089856 1970520576 19.390 100 30 60 0 1995976272 16828768 8626928
00:11:54 43512 8192000000 10908219600 11358179328 1957159264 19.283 99 35 70 4 1983207744 16272768 9775712
00:12:47 24093 8192000000 10918162272 11372404736 1978190672 19.450 100 43 86 1 2012704016 22442992 12070352
00:13:23 39524 8192000000 10919507728 11383336960 1982870608 19.487 100 44 88 0 2017480384 21769632 12840144
00:16:01 92594 8192000000 10906052320 11379310592 1970306832 19.388 99 25 51 1 1987955568 10860560 6788176
00:17:46 69529 8192000000 10897474048 11370377216 1943848096 19.177 98 8 16 0 1954954000 9276848 1829056
00:19:02 53100 8192000000 10894946352 11374698496 1982863824 19.487 100 12 24 0 1995310272 8725856 3720592
00:20:15 32083 8192000000 10903385616 11372277760 1981213904 19.474 100 33 64 2 1997023840 7194608 8615328
00:20:53 63304 8192000000 10913403648 11371782144 1927843216 19.050 97 24 48 2 1942306656 8178992 6284448
00:22:10 41839 8192000000 10864387824 11330174976 1890827856 18.752 96 7 15 0 1899065104 6529872 1707376
00:22:58 21589 8192000000 10876276640 11318210560 1904405488 18.862 97 20 40 0 1917497792 7154880 5937424
00:23:26 38725 8192000000 10883112384 11345788928 1957175888 19.284 100 23 46 0 1973643648 9984976 6482784
00:24:11 66540 8192000000 10877936352 11343441920 1905970272 18.874 97 17 34 0 1921021264 10644256 4406736
00:25:25 18721 8192000000 10880990784 11329425408 1901926592 18.842 97 26 52 1 1917569168 6529392 9113184
00:25:50 32524 8192000000 10879984128 11341492224 1935240624 19.109 99 35 71 0 1955901008 11085136 9575248
00:26:39 43329 8192000000 10901885728 11353575424 1957110208 19.283 100 30 60 0 1975341120 10035648 8195264
00:27:38 113384 8192000000 10873455184 11334791168 1849230912 18.416 94 13 26 1 1862226160 9777456 3217792
00:29:37 95567 8192000000 10860468080 11321978880 1855162832 18.464 95 7 13 0 1865461840 9069856 1229152
00:31:19 59025 8192000000 10856942144 11308019712 1822774416 18.200 94 24 48 0 1840004384 10524256 6705712
00:32:27 14296 8192000000 10865689264 11306332160 1909276080 18.901 99 37 74 0 1930379408 10784016 10319312
00:32:50 8065 8192000000 10879388128 11307307008 1913199440 18.932 99 72 143 1 1942246576 9849264 19197872
00:33:06 13455 8192000000 10891984928 11319365632 1933359696 19.094 100 64 128 4 1962608752 11568352 17680704
00:33:27 34568 8192000000 10858302192 11318071296 1912185488 18.924 99 47 94 0 1937668736 12578368 12904880
00:34:15 124228 8192000000 10868032480 11332079616 1922300464 19.005 99 22 44 0 1938111840 9111312 6700064
00:36:37 36108 8192000000 10856795264 11325829120 1923067488 19.011 99 13 26 1 1938898416 12247248 3583680
00:37:26 11416 8192000000 10864359328 11328933888 1935659712 19.112 100 20 40 0 1958364368 17436480 5268176
00:37:48 29194 8192000000 10866696080 11335217152 1928678032 19.056 99 24 46 0 1945366624 10033616 6654976
00:38:24 46663 8192000000 10850694432 11321196544 1912410000 18.926 98 17 34 2 1924183888 7020128 4753760
00:39:17 53755 8192000000 10871599008 11340107776 1948230288 19.212 100 14 28 0 1960969040 8876560 3862192
00:40:16 59298 8192000000 10886075040 11359854592 1954249808 19.260 100 7 14 1 1965053760 8816544 1987408
00:41:22 88744 8192000000 10908024880 11374002176 1973839920 19.416 100 22 44 0 1993754832 13307952 6606960
00:42:58 68567 8192000000 10911007440 11389714432 1976801344 19.439 100 13 26 1 1994786688 14154400 3830944
00:44:13 40028 8192000000 10908977344 11377360896 1960823312 19.313 99 10 20 0 1979928416 16221968 2883136
00:45:00 40344 8192000000 10875270608 11346030592 1910728288 18.912 97 12 24 0 1933141328 18600112 3812928
00:45:52 39801 8192000000 10882822752 11336609792 1878540624 18.653 96 20 40 1 1896460224 12236112 5683488
00:46:38 49324 8192000000 10882644144 11349659648 1945890368 19.194 100 26 52 1 1965233072 11919904 7422800
00:47:36 99869 8192000000 10887829376 11348488192 1887830208 18.728 96 18 36 0 1908593296 15416144 5346944
00:49:39 97418 8192000000 10892142896 11347509248 1897653424 18.807 97 13 26 0 1915719824 13906368 4160032
00:51:25 43708 8192000000 10906703120 11354050560 1928520784 19.055 98 24 47 1 1947193360 12681136 5991440
00:52:18 37365 8192000000 10912862528 11366834176 1949502736 19.223 99 47 94 1 1977542960 15070880 12969344
00:53:09 70912 8192000000 10899179504 11377827840 1938944576 19.138 99 27 55 1 1962619520 16068640 7606304
00:54:26 105860 8192000000 10895295248 11351257088 1876278608 18.635 95 26 52 1 1900725424 17339952 7106864
00:56:21 48454 8192000000 10900907856 11377872896 1959372688 19.301 100 19 38 1 1986603648 22320944 4910016
00:57:16 115979 8192000000 10890464544 11355688960 1949634816 19.224 99 20 40 0 1972541248 17606400 5300032
00:59:20 45879 8192000000 10867762672 11312226304 1906362224 18.877 97 29 58 2 1924092960 9571120 8159616
01:00:12 57666 8192000000 10865755088 11333787648 1915405568 18.950 98 21 42 0 1932978672 11816768 5756336
01:01:30 53778 8192000000 10876502304 11352711168 1954886048 19.265 100 9 18 1 1972855232 15828816 2140368
01:02:30 75608 8192000000 10881187760 11355271168 1944331024 19.181 99 16 32 2 1960565040 11700496 4533520
01:03:58 87012 8192000000 10886128672 11370754048 1905363072 18.869 97 10 20 1 1918770864 11036528 2371264
01:05:42 33519 8192000000 10880239440 11336376320 1904809776 18.865 97 19 38 0 1919561440 9763216 4988448
01:06:29 51302 8192000000 10904062864 11342311424 1922368144 19.006 98 30 60 1 1943835248 12219760 9247344
01:07:30 18486 8192000000 10898610464 11354816512 1964590304 19.343 100 57 112 2 1993398064 12054480 16753280
01:07:55 94502 8192000000 10884275952 11375898624 1917431680 18.966 98 11 22 0 1935155968 14609248 3115040
01:10:23 65387 8192000000 10897818032 11353092096 1952874624 19.249 100 23 46 0 1969522736 9872032 6776080
01:11:41 30762 8192000000 10901383056 11372367872 1970709248 19.391 100 27 54 0 1990080352 11993312 7377792
01:13:10 95388 8192000000 10892858400 11354808320 1846377216 18.393 94 23 46 2 1860532496 7920208 6235072
01:14:52 157129 8192000000 10861726752 11324370944 1810977776 18.104 92 7 14 0 1822526624 10265968 1282880
01:17:35 35165 8192000000 10864193168 11313258496 1868995472 18.576 96 32 62 3 1885633616 8489744 8148400
01:18:16 133134 8192000000 10845892688 11312467968 1853475360 18.450 96 30 60 1 1870388512 8652432 8260720
01:20:43 42334 8192000000 10872674832 11332169728 1918975328 18.979 100 17 34 0 1934341696 10720832 4645536
01:21:32 68769 8192000000 10878553216 11351281664 1950114848 19.227 100 22 44 0 1963709008 7659664 5934496
01:22:58 87862 8192000000 10870210624 11348168704 1923803024 19.017 98 7 14 1 1936180064 10228672 2148368
01:24:42 67481 8192000000 10858288192 11318534144 1856703248 18.477 95 21 42 0 1872585728 9309920 6572560
01:25:56 53531 8192000000 10859142816 11325353984 1922597456 19.008 99 16 32 0 1939549424 12250160 4701808

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 05-01-2021 01:29:31 to 05-01-2021 01:30:03.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 148 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:02, from 05-01-2021 01:30:04 to 05-01-2021 01:30:06.

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          239340
MON$OLDEST_ACTIVE               241786
MON$OLDEST_SNAPSHOT             241786
MON$NEXT_TRANSACTION            241786
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                       2010752
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 ---
:425: 
:426: mscs-test-161.budzdorov.ru    Tue Jan  5 01:27:25 2021
:427:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:428: 
--- end of diff output ---

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

05.01.21 01:30:07. 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-05 01:30:10 No severe PSQL-related problems occured
05.01.21 01:30:11. End of report.