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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID e0e7b46250ba4f9795ceb55e0face73f
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2020-09-25 13:42
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.00
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 17277432 kB
MemAvailable 31377616 kB
Buffers 0 kB
Cached 14391208 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 19:27:06
DTS_END                         2021-01-05 19:27:06.6380
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/56852
TRN_ID                          245848
ATT_ID                          626
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: 9386.49 19026 1126379
customer order: creation 182.98 340 21957
customer order: refuse 15.70 330 1884
order to supplier: creation 48.41 1259 5809
order to supplier: removal 3.44 97862 413
invoice (draft): creation 48.44 3325 5813
invoice (draft): removal 52.56 763 6307
invoice accept: apply 43.44 17025 5213
invoice accept: cancel 47.56 837 5707
customer reserve: creation 4017.55 168 482106
customer reserve: removal 4618.41 57 554209
realization accept: apply 87.43 206 10491
realization accept: cancel 84.64 108 10157
payment from customer: creation 62.95 129 7554
payment from customer: removal 5.87 99 704
payment to supplier: creation 50.93 142 6112
payment to supplier: removal 3.49 55 419
service: total inventory turnovers 5.39 1033 647
service: total monetary turnovers 6.36 21 763
service: aggregate perf. data 0.92 17573 110
service: refresh index statistics 0.03 239195 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 05-01-2021 19:28:12 to 05-01-2021 19:28:14.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 8349
TEST_TIME 2 5063
TEST_TIME 3 4810
TEST_TIME 4 4431
TEST_TIME 5 5426
TEST_TIME 6 5176
TEST_TIME 7 5427
TEST_TIME 8 5611
TEST_TIME 9 5401
TEST_TIME 10 5721
TEST_TIME 11 5838
TEST_TIME 12 6002
TEST_TIME 13 6289
TEST_TIME 14 6538
TEST_TIME 15 6583
TEST_TIME 16 7428
TEST_TIME 17 8003
TEST_TIME 18 8191
TEST_TIME 19 8068
TEST_TIME 20 8415
TEST_TIME 21 8469
TEST_TIME 22 8451
TEST_TIME 23 9006
TEST_TIME 24 9575
TEST_TIME 25 10054
TEST_TIME 26 10196
TEST_TIME 27 10286
TEST_TIME 28 10381
TEST_TIME 29 10149
TEST_TIME 30 10167
TEST_TIME 31 9965
TEST_TIME 32 9955
TEST_TIME 33 9837
TEST_TIME 34 9842
TEST_TIME 35 9679
TEST_TIME 36 9753
TEST_TIME 37 9639
TEST_TIME 38 9642
TEST_TIME 39 9731
TEST_TIME 40 9589
TEST_TIME 41 9408
TEST_TIME 42 9613
TEST_TIME 43 9543
TEST_TIME 44 9846
TEST_TIME 45 9834
TEST_TIME 46 9829
TEST_TIME 47 9741
TEST_TIME 48 9765
TEST_TIME 49 10031
TEST_TIME 50 10001
TEST_TIME 51 9994
TEST_TIME 52 10076
TEST_TIME 53 10060
TEST_TIME 54 10102
TEST_TIME 55 10088
TEST_TIME 56 9935
TEST_TIME 57 9887
TEST_TIME 58 9835
TEST_TIME 59 9750
TEST_TIME 60 9705
TEST_TIME 61 9671
TEST_TIME 62 9617
TEST_TIME 63 9534
TEST_TIME 64 9592
TEST_TIME 65 9555
TEST_TIME 66 9573
TEST_TIME 67 9539
TEST_TIME 68 9527
TEST_TIME 69 9476
TEST_TIME 70 9617
TEST_TIME 71 9646
TEST_TIME 72 9610
TEST_TIME 73 9532
TEST_TIME 74 9511
TEST_TIME 75 9601
TEST_TIME 76 9701
TEST_TIME 77 9793
TEST_TIME 78 9809
TEST_TIME 79 9714
TEST_TIME 80 9658
TEST_TIME 81 9612
TEST_TIME 82 9586
TEST_TIME 83 9617
TEST_TIME 84 9565
TEST_TIME 85 9509
TEST_TIME 86 9496
TEST_TIME 87 9401
TEST_TIME 88 9426
TEST_TIME 89 9379
TEST_TIME 90 9424
TEST_TIME 91 9410
TEST_TIME 92 9425
TEST_TIME 93 9515
TEST_TIME 94 9510
TEST_TIME 95 9561
TEST_TIME 96 9548
TEST_TIME 97 9633
TEST_TIME 98 9610
TEST_TIME 99 9585
TEST_TIME 100 9619
TEST_TIME 101 9664
TEST_TIME 102 9754
TEST_TIME 103 9717
TEST_TIME 104 9651
TEST_TIME 105 9603
TEST_TIME 106 9620
TEST_TIME 107 9588
TEST_TIME 108 9601
TEST_TIME 109 9550
TEST_TIME 110 9523
TEST_TIME 111 9478
TEST_TIME 112 9462
TEST_TIME 113 9438
TEST_TIME 114 9463
TEST_TIME 115 9445
TEST_TIME 116 9436
TEST_TIME 117 9408
TEST_TIME 118 9472
TEST_TIME 119 9464
TEST_TIME 120 9394

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 05-01-2021 19:28:16 to 05-01-2021 19:28:19.

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 1571730 1571730 0 0.00 0 43689 6 0 0
doc_list_biud 1571730 1571730 0 0.00 0 34923 26 0 0
sp_add_invoice_to_stock 5281 5213 68 1.28 32 145868 17026 0 68
sp_cancel_adding_invoice 5707 5707 0 0.00 5 80607 837 0 0
sp_cancel_client_order 1884 1884 0 0.00 4 11516 330 0 0
sp_cancel_customer_reserve 554209 554209 0 0.00 1 30086 58 0 0
sp_cancel_pay_from_customer 704 704 0 0.00 3 13844 100 0 0
sp_cancel_pay_to_supplier 419 419 0 0.00 3 2731 56 0 0
sp_cancel_supplier_invoice 6309 6307 2 0.03 2 32841 763 0 2
sp_cancel_supplier_order 413 413 0 0.00 9 975318 97863 0 0
sp_cancel_write_off 10157 10157 0 0.00 1 18790 108 0 0
sp_client_order 21957 21957 0 0.00 3 28558 341 0 0
sp_customer_reserve 482106 482106 0 0.00 0 73828 168 0 0
sp_fill_shopping_cart 33576 33576 0 0.00 1 25659 39 0 0
sp_fill_shopping_cart_clo_res 482095 482095 0 0.00 0 17921 15 0 0
sp_get_clo_for_invoice 5202 5202 0 0.00 0 30501 286 0 0
sp_kill_cost_storno 16987 16987 0 0.00 0 18741 56 0 0
sp_kill_qstorno_ret_qs2qd 1125295 1125295 0 0.00 0 32791 31 0 0
sp_kill_qty_storno 594369 594369 0 0.00 0 34921 68 0 0
sp_lock_selected_doc 21701 21701 0 0.00 0 9096 6 0 0
sp_make_cost_storno 29358 29358 0 0.00 0 39596 69 0 0
sp_multiply_rows_for_pdistr 29358 29358 0 0.00 0 6007 28 0 0
sp_multiply_rows_for_qdistr 21957 21957 0 0.00 0 17879 151 0 0
sp_pay_from_customer 7554 7554 0 0.00 4 18380 130 0 0
sp_pay_to_supplier 6112 6112 0 0.00 5 21009 142 0 0
sp_payment_common 13666 13666 0 0.00 1 17895 34 0 0
sp_qd_handle_on_cancel_clo 1884 1884 0 0.00 0 11508 296 0 0
sp_qd_handle_on_invoice_upd_sts 10908 10908 0 0.00 0 34919 320 0 0
sp_qd_handle_on_reserve_upd_sts 10491 10491 0 0.00 0 20022 63 0 0
sp_reserve_write_off 10491 10491 0 0.00 7 24242 206 0 0
sp_supplier_invoice 5813 5813 0 0.00 7 103958 3326 0 0
sp_supplier_order 5809 5809 0 0.00 5 31433 1259 0 0
srv_aggregate_perf_data 110 110 0 0.00 2532 127983 17573 0 0
srv_fill_mon_cache_memory 165 165 0 0.00 1392 127401 31504 0 0
srv_find_qd_qs_mism 1075657 1075657 0 0.00 0 13546 5 0 0
srv_make_invnt_saldo 647 647 0 0.00 18 43451 1033 0 0
srv_make_money_saldo 763 763 0 0.00 1 934 21 0 0
srv_recalc_idx_stat 4 4 0 0.00 159574 367938 239196 0 0
t$perf-abend:sp_add_invoice_to_stock 68 68 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 2 2 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5214 5214 0 0.00 0 18115 177 0 0
t$perf-norm:sp_cancel_adding_invoice 452 452 0 0.00 0 5258 93 0 0
t$perf-norm:sp_cancel_client_order 1884 1884 0 0.00 0 2862 12 0 0
t$perf-norm:sp_cancel_customer_reserve 731 731 0 0.00 0 5313 23 0 0
t$perf-norm:sp_cancel_pay_from_customer 704 704 0 0.00 0 5021 12 0 0
t$perf-norm:sp_cancel_pay_to_supplier 419 419 0 0.00 0 1361 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 411 411 0 0.00 0 1395 13 0 0
t$perf-norm:sp_cancel_supplier_order 413 413 0 0.00 0 22086 1448 0 0
t$perf-norm:sp_cancel_write_off 995 995 0 0.00 0 2087 7 0 0
t$perf-norm:sp_client_order 21957 21957 0 0.00 0 9343 17 0 0
t$perf-norm:sp_customer_reserve 1056 1056 0 0.00 0 1974 8 0 0
t$perf-norm:sp_pay_from_customer 7554 7554 0 0.00 0 6240 11 0 0
t$perf-norm:sp_pay_to_supplier 6112 6112 0 0.00 0 6786 9 0 0
t$perf-norm:sp_reserve_write_off 10491 10491 0 0.00 0 5594 10 0 0
t$perf-norm:sp_supplier_invoice 5814 5814 0 0.00 0 11700 24 0 0
t$perf-norm:sp_supplier_order 5809 5809 0 0.00 0 14227 18 0 0
t$perf-norm:srv_aggregate_perf_data 110 110 0 0.00 0 939 14 0 0
t$perf-norm:srv_fill_mon_cache_memory 165 165 0 0.00 0 580 6 0 0
t$perf-norm:srv_make_invnt_saldo 647 647 0 0.00 0 1641 20 0 0
t$perf-norm:srv_make_money_saldo 763 763 0 0.00 0 484 9 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 4 3 0 0
v_add_invoice_to_stock 10538 10402 136 1.29 0 7424 19 0 136
v_all_customers 40388 40388 0 0.00 0 19 1 0 0
v_all_suppliers 32150 32150 0 0.00 0 62 1 0 0
v_all_wares 43914 43914 0 0.00 0 31 1 0 0
v_cancel_adding_invoice 904 904 0 0.00 0 2708 11 0 0
v_cancel_client_order 3768 3768 0 0.00 0 3041 8 0 0
v_cancel_customer_prepayment 1408 1408 0 0.00 0 1385 6 0 0
v_cancel_customer_reserve 1462 1462 0 0.00 0 1868 6 0 0
v_cancel_payment_to_supplier 838 838 0 0.00 0 318 3 0 0
v_cancel_supplier_invoice 826 822 4 0.48 0 5353 26 0 4
v_cancel_supplier_order 826 826 0 0.00 0 995 5 0 0
v_cancel_write_off 1990 1990 0 0.00 0 4144 15 0 0
v_max_id_clo_ord 5809 5809 0 0.00 0 2846 2 0 0
v_max_id_clo_res 1056 1056 0 0.00 0 22848 47 0 0
v_max_id_ord_sup 5810 5810 0 0.00 0 6545 3 0 0
v_max_non_paid_invoice 1656 1656 0 0.00 0 370 2 0 0
v_max_non_paid_realizn 3922 3922 0 0.00 0 2199 4 0 0
v_min_id_clo_ord 5809 5809 0 0.00 0 3027 7 0 0
v_min_id_clo_res 1056 1056 0 0.00 0 4336 7 0 0
v_min_id_ord_sup 5810 5810 0 0.00 0 7623 7 0 0
v_min_non_paid_invoice 6112 6112 0 0.00 0 17888 20 0 0
v_min_non_paid_realizn 7554 7554 0 0.00 0 14385 24 0 0
v_our_firm 10790 10790 0 0.00 0 35 1 0 0
v_reserve_write_off 20982 20982 0 0.00 0 4311 6 0 0
x_lock_depdocs_on_canc_invoice 11603 11603 0 0.00 0 13876 115 0 0
x_lock_depdocs_on_canc_sup_ord 413 413 0 0.00 0 15268 336 0 0
x_make_qstorno_1000_1200 5809 5809 0 0.00 1 31427 1175 0 0
x_make_qstorno_1200_2000 5813 5813 0 0.00 3 103936 3188 0 0
x_make_qstorno_2100_3300 482106 482106 0 0.00 0 73828 151 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 05-01-2021 19:28:20 to 05-01-2021 19:28:24.

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
16:57:10 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:16 17860 8192000000 10247502800 10551816192 745226304 8.338 59 43 87 2 761688816 2126160 14336352
16:57:42 24714 8192000000 10335726192 10655277056 1380326288 14.419 100 84 168 1 1412654960 4795008 27533664
16:58:18 32800 8192000000 10397778112 10720133120 1439383104 14.944 100 92 184 0 1475356816 6274096 29699616
16:59:05 18249 8192000000 10412359680 10741751808 1468998208 15.205 100 87 174 1 1504513024 7507040 28007776
16:59:35 17158 8192000000 10422710560 10758680576 1484142864 15.338 100 87 171 3 1519287744 7809952 27334928
17:00:07 27900 8192000000 10451813024 10788556800 1503060832 15.503 100 91 182 1 1540963456 8720608 29182016
17:00:48 19821 8192000000 10481497104 10821603328 1528569728 15.725 100 83 166 0 1563916384 9068864 26277792
17:01:19 20284 8192000000 10510577712 10855821312 1559835024 15.995 100 86 172 0 1596723088 9736480 27151584
17:01:47 19407 8192000000 10529886624 10881564672 1583844992 16.201 100 77 152 2 1617124800 10231696 23048112
17:02:16 15700 8192000000 10554093536 10909212672 1613023392 16.450 100 83 166 0 1649444352 11303696 25117264
17:02:42 10125 8192000000 10565704256 10923433984 1624941600 16.552 100 73 146 0 1658889568 11773360 22174608
17:03:02 9982 8192000000 10591889264 10953547776 1648721728 16.754 100 88 174 2 1687357216 12399008 26236480
17:03:27 13884 8192000000 10621143232 10985377792 1668548208 16.921 100 76 153 1 1703178976 12180256 22450512
17:03:49 9564 8192000000 10633001056 11000123392 1685892560 17.067 100 83 164 1 1722836704 13094112 23850032
17:04:07 6907 8192000000 10643871696 11008684032 1701437936 17.197 100 81 162 2 1737821392 13314384 23069072
17:04:21 7616 8192000000 10650919312 11020505088 1712739456 17.292 100 87 172 0 1751631648 13871824 25020368
17:04:36 5541 8192000000 10656321712 11031183360 1718930848 17.343 100 86 172 1 1758921936 15074288 24916800
17:04:49 4534 8192000000 10670866624 11041165312 1727371424 17.414 100 85 168 1 1766045584 14613760 24060400
17:05:01 4565 8192000000 10680594672 11053481984 1738704624 17.508 100 88 174 2 1777349552 13733376 24911552
17:05:13 3706 8192000000 10683397680 11059695616 1739774560 17.517 100 74 148 0 1774433568 13788224 20870784
17:05:24 4441 8192000000 10695106384 11073691648 1757888672 17.667 100 82 163 4 1793679856 12781440 23009744
17:05:36 3124 8192000000 10706779280 11085664256 1765784224 17.732 100 85 170 1 1803169888 12733344 24652320
17:05:46 2633 8192000000 10712152320 11089391616 1773419952 17.795 100 85 167 4 1810295984 12177936 24698096
17:05:55 2421 8192000000 10725076016 11102109696 1778159808 17.834 100 89 178 0 1816522640 13139520 25223312
17:06:05 2743 8192000000 10723769952 11106824192 1788188464 17.917 100 85 170 1 1825470544 12848256 24433824
17:06:15 3172 8192000000 10733335360 11114598400 1798092064 17.998 100 92 182 1 1836925568 13276448 25557056
17:06:25 2124 8192000000 10740292112 11125342208 1801195248 18.024 100 87 172 2 1838464688 13310544 23958896
17:06:34 7906 8192000000 10741978720 11127709696 1805007280 18.055 100 94 188 0 1846725984 15222752 26495952
17:06:48 4603 8192000000 10745698048 11131604992 1805654656 18.060 100 76 151 2 1839837712 13267312 20915744
17:07:00 1926 8192000000 10762622592 11141857280 1820095792 18.178 100 92 182 1 1862376304 14745056 27535456
17:07:09 1924 8192000000 10768857680 11156869120 1828017408 18.243 100 92 183 2 1867062672 12830336 26214928
17:07:17 1890 8192000000 10782440800 11168821248 1838050080 18.325 100 93 181 2 1875868912 12121040 25697792
17:07:26 2812 8192000000 10783368656 11168874496 1841954320 18.357 100 92 184 1 1879781072 11923056 25903696
17:07:35 1961 8192000000 10788901040 11175198720 1847766752 18.404 100 84 168 0 1884202080 12798384 23636944
17:07:43 1525 8192000000 10785878224 11173191680 1845964960 18.389 100 89 179 2 1884430832 12842992 25622880
17:07:50 1919 8192000000 10801675792 11187519488 1852828320 18.445 100 90 181 1 1892758208 13360016 26569872
17:07:59 1631 8192000000 10805929072 11191066624 1856621536 18.476 100 89 178 1 1895691584 12928672 26141376
17:08:07 1321 8192000000 10804577712 11191828480 1859380080 18.498 100 94 190 0 1898260432 12274272 26606080
17:08:15 36095 8192000000 10777112848 11184185344 1857957760 18.487 100 62 120 2 1885409104 10174128 17277216
17:08:57 9855 8192000000 10766061104 11188678656 1854504000 18.459 100 44 88 3 1875654320 8784304 12366016
17:09:17 8868 8192000000 10781232592 11198398464 1861807008 18.518 100 40 80 2 1880206720 7562224 10837488
17:09:33 5592 8192000000 10772217056 11193040896 1859498800 18.499 100 30 58 0 1875468864 7926880 8043184
17:09:48 5556 8192000000 10777475648 11201875968 1866461920 18.556 100 34 68 0 1882745600 6675072 9608608
17:10:00 5609 8192000000 10780673872 11201122304 1865115280 18.545 100 26 52 0 1878877888 6240160 7522448
17:10:13 4779 8192000000 10786507904 11207606272 1868978432 18.576 100 35 70 3 1888005808 9397424 9629952
17:10:29 10060 8192000000 10774466576 11207090176 1866774064 18.558 100 19 36 1 1879110208 6896096 5440048
17:10:47 13951 8192000000 10768468880 11209490432 1871485104 18.596 100 19 38 1 1884046752 6478048 6083600
17:11:10 11510 8192000000 10786345792 11214307328 1874349392 18.619 100 19 37 0 1885706704 5646864 5710448
17:11:30 8278 8192000000 10801732848 11221151744 1879310208 18.660 100 31 62 2 1893489056 5500736 8678112
17:11:44 8770 8192000000 10788209360 11217973248 1878515504 18.653 100 16 33 0 1889278624 5916528 4846592
17:11:59 8461 8192000000 10788573712 11223212032 1885776032 18.712 100 30 60 1 1900737344 7049696 7911616
17:12:18 17908 8192000000 10792931888 11227938816 1882355888 18.684 100 14 28 1 1893252752 6896672 4000192
17:12:44 10804 8192000000 10803726896 11226263552 1886623760 18.719 100 23 46 3 1898624256 5558320 6442176
17:13:01 66964 8192000000 10809763312 11241447424 1889450544 18.741 100 24 50 1 1901975408 5358208 7166656
17:14:14 11153 8192000000 10805425984 11243515904 1893518896 18.774 100 20 39 4 1905300288 6154400 5626992
17:14:33 8532 8192000000 10802667296 11235430400 1877561168 18.645 99 26 52 2 1891525952 6757328 7207456
17:14:51 7145 8192000000 10809267456 11242483712 1893741024 18.776 100 22 43 2 1906034400 6054672 6238704
17:15:05 4950 8192000000 10824619136 11251884032 1896865312 18.801 100 38 76 1 1915106400 8105632 10135456
17:15:17 3621 8192000000 10807859360 11246272512 1896215792 18.796 100 21 42 2 1908428080 6156096 6056192
17:15:29 8095 8192000000 10807764624 11245268992 1895876272 18.793 100 24 48 0 1909671216 7295760 6499184
17:15:46 6527 8192000000 10812620752 11244371968 1874817984 18.623 99 18 35 0 1889981952 10244608 4919360
17:16:04 8325 8192000000 10817785600 11247091712 1895985104 18.794 100 27 54 1 1909884160 6603648 7295408
17:16:21 8927 8192000000 10806102032 11248029696 1894515936 18.782 100 16 32 0 1904591344 5372512 4702896
17:16:38 15344 8192000000 10792143824 11227181056 1819546496 18.174 96 13 26 2 1828110224 4989072 3574656
17:17:03 6464 8192000000 10789685312 11218386944 1857737376 18.485 99 17 35 2 1868473152 6219008 4516768
17:17:16 9246 8192000000 10783945280 11225968640 1860774736 18.510 99 26 52 3 1874960016 7150080 7035200
17:17:35 10852 8192000000 10762530320 11195875328 1768808784 17.757 94 13 27 0 1777227488 4640768 3777936
17:17:52 64551 8192000000 10756235264 11189452800 1799592176 18.011 96 36 69 3 1813448112 4294880 9561056
17:19:03 12393 8192000000 10770902624 11194028032 1820342464 18.180 98 24 48 1 1832700176 5745824 6611888
17:19:25 6067 8192000000 10745545552 11167567872 1770973328 17.775 96 21 42 0 1782885424 5426528 6485568
17:19:39 4302 8192000000 10761357728 11181051904 1808335200 18.082 98 26 52 0 1822208544 5982336 7891008
17:19:52 5066 8192000000 10727854864 11144687616 1785049968 17.891 98 32 64 2 1801376304 7377600 8948736
17:20:05 9532 8192000000 10703210912 11122077696 1729027920 17.427 95 22 45 3 1740992288 5462704 6501664
17:20:23 4182 8192000000 10726996816 11140202496 1795637712 17.978 99 25 50 3 1808679136 6322656 6718768
17:20:37 10343 8192000000 10692712640 11105206272 1649931472 16.764 91 19 38 0 1660569616 4866832 5771312
17:20:53 10197 8192000000 10641897536 11048058880 1645251776 16.724 93 23 46 0 1657564352 5356704 6955872
17:21:11 9006 8192000000 10662241568 11069657088 1653169984 16.791 94 24 48 1 1664410832 4653872 6586976
17:21:29 12959 8192000000 10681101904 11101216768 1759877104 17.683 99 32 64 0 1774762704 5265584 9620016
17:21:48 11876 8192000000 10700461888 11124420608 1774744304 17.806 99 24 48 3 1787520624 5646432 7129888
17:22:06 13046 8192000000 10712145200 11126587392 1763079232 17.710 98 15 30 0 1773168752 5672336 4417184
17:22:26 55006 8192000000 10748684912 11153084416 1807334896 18.074 100 33 66 5 1824385920 5286144 11764880
17:23:46 13735 8192000000 10723883264 11153899520 1815415440 18.140 100 19 38 0 1827159104 6592928 5150736
17:24:08 8777 8192000000 10751374960 11165708288 1824716752 18.216 100 28 57 1 1837991600 5667168 7607680
17:24:25 7876 8192000000 10776646080 11186913280 1833683632 18.289 100 41 82 0 1857562320 12723424 11155264
17:24:42 10296 8192000000 10751276320 11174993920 1831566752 18.272 100 24 47 1 1843187760 5292416 6328592
17:25:02 5984 8192000000 10751396400 11178192896 1839132928 18.334 100 25 50 2 1852747168 6318352 7295888
17:25:14 12305 8192000000 10752279744 11180814336 1840507920 18.345 100 21 42 2 1851382640 4815216 6059504
17:25:32 13364 8192000000 10756146256 11181142016 1840478656 18.345 100 19 38 0 1851467344 5429920 5558768
17:25:53 8871 8192000000 10762254064 11188023296 1847058176 18.398 100 22 44 1 1859871632 6285824 6527632
17:26:11 8927 8192000000 10771417984 11195469824 1850843872 18.429 100 23 46 0 1866867648 9469952 6553824
17:26:30 17135 8192000000 10768489488 11191865344 1852558800 18.443 100 13 26 0 1861833552 5557904 3716848
17:26:54 13362 8192000000 10776155248 11204136960 1857240992 18.481 100 15 30 1 1866670560 5474800 3954768
17:27:13 17354 8192000000 10795552480 11220840448 1877351216 18.644 100 34 67 2 1893121376 5964992 9805168
17:27:51 12609 8192000000 10832515632 11239387136 1896465152 18.798 100 53 106 0 1920277040 7481904 16329984
17:28:13 59438 8192000000 10837858560 11261689856 1906056592 18.875 100 39 78 3 1924915504 7209600 11649312
17:29:21 66952 8192000000 10820180720 11257946112 1911543392 18.919 100 14 26 2 1921749040 5388000 4817648
17:30:37 60018 8192000000 10854501024 11289841664 1924810368 19.025 100 27 53 4 1942496912 10007648 7678896
17:31:45 29992 8192000000 10877971968 11307020288 1941445552 19.158 100 46 92 1 1968647632 13984208 13217872
17:32:25 7325 8192000000 10879181792 11304861696 1941246176 19.157 100 49 98 1 1971806160 16404096 14155888
17:32:45 15965 8192000000 10870835984 11306385408 1940190032 19.148 100 35 70 1 1962661088 12178608 10292448
17:33:10 19945 8192000000 10897327552 11320156160 1951984784 19.242 100 41 82 1 1979119984 14364256 12770944
17:33:39 15426 8192000000 10890578256 11318185984 1940315744 19.149 99 53 106 2 1972755936 15979584 16460608
17:34:08 23970 8192000000 10894911008 11320868864 1949151648 19.220 100 55 110 1 1983433312 17572064 16709600
17:34:40 5746 8192000000 10906077776 11328851968 1956471904 19.278 100 55 109 0 1989826000 17261936 16092160
17:34:54 25306 8192000000 10903596512 11336294400 1959179840 19.300 100 52 104 1 1992075376 17527152 15368384
17:35:27 21401 8192000000 10916479104 11350339584 1964460816 19.341 100 38 74 3 1996081264 20723472 10896976
17:35:57 4588 8192000000 10916152112 11348471808 1970641408 19.391 100 41 80 2 2003560544 20903328 12015808
17:36:15 20769 8192000000 10937441440 11368579072 1975498832 19.429 100 46 90 3 2011486928 22402128 13585968
17:36:42 9022 8192000000 10930300000 11360907264 1979852192 19.464 100 52 103 2 2020024720 24416608 15755920
17:37:02 4102 8192000000 10938231088 11362865152 1980917728 19.472 100 67 133 1 2026891616 25850224 20123664
17:37:14 5987 8192000000 10936765424 11357290496 1963779152 19.336 99 67 132 0 2011283392 27710336 19793904
17:37:27 9570 8192000000 10943125792 11357392896 1971083360 19.394 100 62 124 1 2016909472 26778208 19047904
17:37:46 10198 8192000000 10938514576 11360362496 1978061728 19.449 100 72 141 1 2025861360 25897904 21901728
17:38:04 10403 8192000000 10937190192 11359805440 1982810304 19.487 100 66 131 0 2029400256 27048064 19541888
17:38:24 2878 8192000000 10945091456 11367718912 1982771952 19.487 100 69 135 1 2030474704 27277216 20425536
17:38:40 7247 8192000000 10959353936 11377061888 1992885536 19.567 100 66 132 1 2040951376 28117040 19948800
17:38:56 3623 8192000000 10950326816 11375341568 1991340416 19.554 100 68 135 1 2039588096 27735696 20511984
17:39:10 5569 8192000000 10958642784 11382132736 1995554496 19.588 100 77 154 0 2047794128 28969680 23269952
17:39:23 5741 8192000000 10962658656 11387047936 2002161440 19.640 100 72 141 1 2052992064 29475776 21354848
17:39:38 3291 8192000000 10966157760 11392970752 2002496224 19.642 100 74 148 0 2054121280 29256224 22368832
17:39:50 2002 8192000000 10980342464 11397165056 2012121664 19.718 100 84 168 0 2067438848 30270480 25046704
17:40:01 3307 8192000000 10964217488 11385434112 1991459696 19.555 99 77 154 0 2046662848 31719408 23483744
17:40:13 9156 8192000000 10972604608 11397206016 2003259856 19.648 100 62 124 0 2054330192 32303392 18766944
17:40:31 3639 8192000000 10977249456 11388911616 1993737200 19.573 99 74 147 4 2051192192 34792928 22662064
17:40:43 3558 8192000000 10984787520 11407691776 2010562912 19.706 100 70 139 0 2066902640 35314192 21025536
17:40:53 3434 8192000000 10980514448 11405676544 2008977184 19.693 100 76 152 0 2068748032 36074848 23696000
17:41:03 3749 8192000000 10950993392 11373744128 1971154576 19.395 99 69 136 0 2027004192 34451520 21398096
17:41:13 3441 8192000000 10972945584 11384868864 1994430128 19.579 100 86 169 0 2056354784 34692544 27232112
17:41:23 6295 8192000000 10961730672 11387191296 1986287728 19.514 100 73 145 2 2046000864 36622912 23090224
17:41:44 2919 8192000000 10963918080 11394805760 1997773664 19.605 100 67 132 0 2052739680 33906256 21059760
17:41:58 3712 8192000000 10966970688 11386892288 1990181984 19.545 100 68 136 2 2045754832 34245840 21327008
17:42:12 2458 8192000000 10975968352 11391758336 1997039040 19.599 100 74 146 0 2053942016 33374512 23528464
17:42:22 1953 8192000000 10968558336 11386572800 1994000896 19.575 100 82 164 1 2055242576 34823440 26418240
17:42:31 3198 8192000000 10978828944 11394490368 1997062688 19.600 100 85 169 0 2059983984 37544752 25376544
17:42:42 8215 8192000000 10964486896 11380445184 1980308688 19.467 99 77 154 0 2043739584 39622464 23808432
17:42:57 3471 8192000000 10966080064 11390074880 1972799184 19.408 99 68 136 1 2034632720 40529632 21303904
17:43:08 7395 8192000000 10982257792 11405094912 1999123968 19.616 100 82 164 1 2066256640 41202848 25929824
17:43:24 2596 8192000000 10964473552 11385102336 1971292992 19.396 99 79 156 2 2037726720 41972992 24460736
17:43:34 1926 8192000000 10962191568 11378098176 1962118240 19.323 99 78 155 1 2027981280 40903728 24959312
17:43:43 1791 8192000000 10966971440 11384741888 1983174736 19.490 100 78 156 2 2045571984 36851424 25545824
17:43:52 1600 8192000000 10971557040 11386556416 1987695920 19.526 100 88 176 1 2050558768 35587552 27275296
17:44:01 4811 8192000000 10954485680 11377729536 1963652768 19.335 99 66 132 0 2020800320 36092368 21055184
17:44:13 3238 8192000000 10963206928 11374452736 1949311456 19.221 98 83 166 2 2012105488 37626864 25167168
17:44:23 2692 8192000000 10978574912 11389374464 1986673792 19.518 100 83 166 0 2050689936 38324704 25691440
17:44:33 2879 8192000000 10984046384 11393921024 1992822864 19.566 100 83 165 0 2057910416 39004816 26082736
17:44:43 6653 8192000000 10948251840 11382542336 1969826048 19.384 99 53 106 0 2022963936 36475440 16662448
17:44:58 9214 8192000000 10934798416 11375128576 1964855264 19.345 99 46 90 3 2010491312 31180320 14455728
17:45:19 5163 8192000000 10949928960 11385036800 1984759968 19.502 100 50 100 2 2033396256 31696464 16939824
17:45:35 3277 8192000000 10942070848 11370008576 1971944992 19.401 99 58 115 3 2022614800 32783056 17886752
17:45:45 10597 8192000000 10952355392 11393544192 1983558176 19.493 100 54 108 3 2033894576 33477344 16859056
17:46:11 5716 8192000000 10954231456 11389882368 1985087568 19.505 100 53 106 2 2039032864 37067840 16877456
17:46:28 14481 8192000000 10944031376 11381030912 1968188704 19.371 99 48 97 0 2014795584 31286048 15320832
17:46:58 5638 8192000000 10948085520 11378163712 1974845888 19.424 100 64 125 3 2031465424 36913792 19705744
17:47:11 1391 8192000000 10927328784 11345575936 1950971840 19.234 99 92 183 0 2018035168 37731216 29332112
17:47:18 7720 8192000000 10919766672 11352195072 1949690784 19.224 100 64 127 0 2006912192 37909648 19311760
17:47:41 5499 8192000000 10930382656 11354148864 1937807232 19.129 99 66 132 1 1999667280 40991504 20868544
17:48:07 12785 8192000000 10927820928 11360342016 1956149008 19.275 100 40 80 2 2003119120 33544400 13425712
17:48:27 17540 8192000000 10921993952 11371220992 1963143136 19.331 100 31 62 0 2005750224 32187600 10419488
17:48:52 5142 8192000000 10926326416 11360854016 1957261280 19.284 100 46 92 1 2005119696 33055792 14802624
17:49:04 2616 8192000000 10932647104 11364872192 1962163248 19.323 100 50 100 2 2012848176 34217360 16467568
17:49:15 6148 8192000000 10937613376 11363106816 1959307456 19.301 100 57 114 1 2015329008 37009088 19012464
17:49:28 3888 8192000000 10932551584 11361710080 1956576848 19.279 100 56 111 1 2012950816 38970240 17403728
17:49:42 6004 8192000000 10916935584 11363655680 1951639584 19.240 100 32 64 2 2002207600 39249184 11318832
17:50:02 16548 8192000000 10868628112 11309903872 1902817424 18.849 98 30 60 1 1944731392 31419888 10494080
17:50:28 21572 8192000000 10902688928 11351261184 1947711008 19.208 100 28 56 0 1987136656 29888048 9537600
17:51:01 13611 8192000000 10895895888 11342761984 1931895280 19.082 99 33 65 3 1975946832 32680224 11371328
17:51:23 18274 8192000000 10886160896 11336921088 1904298608 18.861 98 21 42 1 1945212160 33876912 7036640
17:51:58 24661 8192000000 10838684064 11281084416 1835825184 18.307 95 20 40 1 1865878960 23295008 6758768
17:52:29 22875 8192000000 10856206976 11311575040 1882090976 18.682 99 14 28 0 1905528176 19061360 4375840
17:53:05 18831 8192000000 10849561648 11306807296 1899581696 18.823 99 11 22 0 1923199184 19828240 3789248
17:54:03 34326 8192000000 10837732784 11282460672 1870169072 18.586 99 12 24 0 1894888128 20645120 4073936
17:54:44 22692 8192000000 10842921840 11286441984 1877930320 18.648 98 30 60 0 1901700720 14877808 8892592
17:55:20 25537 8192000000 10832763328 11267272704 1879817184 18.664 99 46 86 1 1897599824 4781008 13001632
17:55:55 22826 8192000000 10869248864 11307950080 1920843776 18.994 100 42 82 3 1943387408 10268448 12275184
17:56:38 76869 8192000000 10853001152 11298455552 1854504224 18.459 96 36 72 2 1877653552 13688640 9460688
17:58:05 127400 8192000000 10863672992 11298287616 1875007344 18.625 97 30 60 1 1895128448 11265920 8855184
18:00:21 42176 8192000000 10896617984 11329236992 1930662192 19.072 99 38 76 2 1952176016 10596704 10917120
18:01:10 102648 8192000000 10857116784 11301040128 1869811328 18.583 96 29 54 0 1892715744 15173664 7730752
18:02:59 6777 8192000000 10882436640 11336544256 1944889616 19.186 100 26 52 0 1971927120 19265936 7771568
18:03:30 4270 8192000000 10881698000 11347857408 1957209344 19.284 100 16 30 3 1975704256 14238528 4256384
18:03:42 10173 8192000000 10889369392 11336667136 1961992464 19.322 100 17 31 0 1980438880 14154992 4291424
18:04:01 20122 8192000000 10916424368 11364487168 1978113488 19.450 100 31 61 2 2001098880 13993792 8991600
18:04:31 42663 8192000000 10925700000 11369844736 1964737488 19.344 99 45 90 1 1994818928 16828608 13252832
18:05:43 26896 8192000000 10921402160 11385851904 1982526624 19.485 100 23 46 3 2010782016 21085856 7169536
18:06:24 39744 8192000000 10915610640 11390853120 1964942160 19.345 99 16 32 1 1996189648 26181872 5065616
18:07:13 43648 8192000000 10926691280 11392991232 1983984368 19.496 100 14 28 0 2011064944 22596128 4484448
18:08:09 40930 8192000000 10933662528 11381669888 1969110048 19.378 99 20 40 2 1997592384 22096672 6385664
18:09:04 26014 8192000000 10928799888 11396927488 1991962384 19.559 100 27 54 1 2029647424 28858336 8826704
18:09:39 42256 8192000000 10924345376 11398139904 1984627680 19.501 100 11 22 0 2009676000 21760368 3287952
18:11:01 34150 8192000000 10919681040 11390304256 1981364272 19.475 100 24 48 0 2013307328 23924544 8018512
18:11:59 55816 8192000000 10910918848 11372834816 1975486928 19.429 100 14 28 1 1987355664 8170352 3698384
18:13:02 79413 8192000000 10934098928 11390705664 1963929760 19.337 99 22 44 2 1983221552 12940368 6351424
18:14:27 58913 8192000000 10925218880 11382120448 1957779056 19.288 98 27 54 0 1985366784 19836448 7751280
18:15:39 26019 8192000000 10938388176 11397337088 1993677424 19.573 100 30 61 2 2016742912 14288576 8776912
18:16:11 68378 8192000000 10930220192 11419095040 1992622912 19.565 100 13 26 1 2016367344 19823616 3920816
18:17:26 71833 8192000000 10933336128 11395133440 1960082624 19.307 98 10 21 0 1979183472 16069296 3031552
18:18:45 78950 8192000000 10923823744 11400114176 1975345168 19.428 99 11 22 1 1993761904 15306016 3110720
18:20:10 85630 8192000000 10923450832 11407912960 1978678000 19.454 99 14 27 0 1995230144 12776752 3775392
18:21:51 121065 8192000000 10899133872 11359195136 1862930992 18.527 93 20 40 0 1878464512 9008512 6525008
18:24:20 79562 8192000000 10900748912 11383689216 1958988512 19.298 99 24 48 2 1980711664 14804272 6918880
18:25:46 43761 8192000000 10883424800 11348312064 1953726496 19.256 99 15 30 0 1966618464 8232544 4659424
18:26:37 6036 8192000000 10903373136 11355140096 1972003520 19.401 100 39 78 1 1992337632 9453616 10880496
18:26:54 28280 8192000000 10903233408 11361914880 1928015280 19.051 97 33 67 2 1945992448 8420896 9556272
18:27:31 37230 8192000000 10889704976 11358478336 1948039168 19.211 98 25 50 3 1961794432 6823440 6931824
18:28:15 69412 8192000000 10881536832 11348180992 1925455024 19.031 97 13 26 0 1937034032 7879072 3699936
18:29:30 68949 8192000000 10880770960 11356237824 1964542720 19.342 100 10 20 0 1976406256 9258496 2605040
18:31:25 43431 8192000000 10881727296 11349676032 1945996624 19.195 99 10 20 1 1956288064 7626480 2664960
18:32:16 43575 8192000000 10871308432 11335196672 1885072784 18.706 96 21 42 0 1899458912 8597680 5788448
18:33:06 45635 8192000000 10887029504 11353616384 1928919600 19.058 98 21 40 1 1941751008 7596272 5235136
18:34:01 25166 8192000000 10899260800 11359047680 1940653248 19.152 98 36 72 0 1963690064 12574848 10461968
18:34:36 24129 8192000000 10899314736 11357634560 1943922288 19.178 99 31 62 2 1968626112 16184416 8519408
18:35:07 62311 8192000000 10860183104 11313741824 1864484800 18.540 95 21 42 1 1887919424 17659568 5775056
18:36:16 62161 8192000000 10832195424 11307556864 1819294912 18.172 94 30 60 0 1848832000 20214976 9322112
18:37:34 53065 8192000000 10851382592 11303567360 1845001840 18.382 96 16 32 0 1863336240 14020528 4313872
18:38:33 62546 8192000000 10839096368 11308400640 1843338208 18.368 96 18 36 0 1859362992 11131504 4893280
18:39:42 15406 8192000000 10859778032 11306242048 1890132832 18.747 98 23 46 0 1903177632 6898928 6145872
18:40:10 32010 8192000000 10880745024 11310850048 1871249840 18.594 97 44 88 0 1896257376 12301920 12705616
18:40:49 17504 8192000000 10889683040 11325358080 1928887824 19.058 100 55 110 0 1964729888 19873328 15968736
18:41:13 19077 8192000000 10881855200 11328131072 1927424272 19.046 100 42 84 0 1958762896 19546448 11792176
18:43:01 67160 8192000000 10853261792 11313115136 1848107056 18.407 96 13 26 1 1868844624 17047200 3690368
18:44:15 38425 8192000000 10844041600 11316375552 1886537744 18.718 98 19 37 1 1905407808 12824848 6045216
18:45:11 84988 8192000000 10846448400 11299463168 1819321856 18.172 94 30 60 1 1837423856 9716016 8385984
18:47:30 78817 8192000000 10858881840 11319889920 1904481696 18.862 99 20 40 2 1918509920 8788768 5239456
18:49:51 27849 8192000000 10853440192 11318116352 1915412272 18.950 99 13 26 1 1930564864 11570752 3581840
18:50:34 46590 8192000000 10835954512 11306274816 1897018480 18.802 98 6 12 0 1905942368 7751792 1172096
18:51:38 42073 8192000000 10835983040 11304525824 1893475056 18.774 98 5 10 0 1899501472 4847344 1179072
18:52:27 52570 8192000000 10844237168 11312717824 1906516208 18.879 99 10 20 0 1915821584 6698672 2606704
18:53:29 45683 8192000000 10839137248 11318239232 1929372160 19.062 100 8 17 0 1938833456 7337936 2123360
18:54:24 67531 8192000000 10847506912 11326164992 1922278160 19.005 99 16 32 0 1935102752 8454464 4370128
18:55:38 73168 8192000000 10867787568 11332407296 1923451728 19.014 99 14 28 0 1935985296 7917600 4615968
18:56:58 54197 8192000000 10895873792 11368550400 1968315936 19.372 100 27 54 1 1985145840 9410112 7419792
18:58:04 63901 8192000000 10912317248 11382571008 1985435184 19.508 100 21 40 3 2003691328 12341632 5914512
18:59:14 31729 8192000000 10901889744 11377786880 1981188272 19.474 100 19 38 0 1999247792 12563504 5496016
18:59:55 61197 8192000000 10898845536 11357421568 1927351680 19.046 97 27 55 2 1951808416 15979600 8477136
19:01:06 32008 8192000000 10924429232 11379580928 1987593456 19.525 100 30 60 0 2006025152 9984416 8447280
19:01:45 58917 8192000000 10887637184 11365515264 1942835904 19.169 98 19 38 1 1958618688 10755088 5027696
19:02:50 43318 8192000000 10918787440 11371212800 1939422752 19.142 98 30 60 1 1956800512 9260640 8117120
19:03:56 41941 8192000000 10907723936 11379580928 1962799072 19.328 99 16 32 0 1978666784 10943872 4923840
19:04:44 89753 8192000000 10941996880 11384479744 1948337744 19.213 98 28 55 1 1968210864 11782784 8090336
19:06:24 29210 8192000000 10929328896 11385176064 1988220016 19.530 100 26 52 0 2007129728 12069664 6840048
19:07:00 76920 8192000000 10924032224 11403202560 1954082464 19.259 98 18 36 0 1975392608 16399216 4910928
19:08:23 46226 8192000000 10934230928 11406557184 1996291440 19.593 100 17 34 2 2017686768 16900800 4494528
19:09:23 51855 8192000000 10929399376 11421548544 1974974992 19.425 99 7 14 1 2000611328 23622480 2013856
19:10:23 90819 8192000000 10892833520 11354972160 1910483664 18.911 96 14 28 0 1925810720 11043440 4283616
19:12:41 85984 8192000000 10887735344 11364429824 1899280304 18.821 96 17 33 1 1911248192 7978160 3989728
19:14:45 55019 8192000000 10873099728 11355537408 1944091344 19.179 99 17 32 1 1963639664 15004928 4543392
19:15:54 53930 8192000000 10863867248 11339497472 1898510048 18.814 97 4 8 0 1906972816 7452384 1010384
19:17:06 61026 8192000000 10858432496 11331301376 1900756208 18.832 97 14 28 1 1913493760 8346240 4391312
19:18:14 77612 8192000000 10865409216 11343474688 1917717504 18.969 98 11 22 0 1930108544 8972704 3418336
19:19:40 54412 8192000000 10844997536 11324809216 1889907520 18.745 97 9 18 0 1902881840 10200832 2773488
19:20:41 44776 8192000000 10851582544 11333394432 1901856496 18.841 98 14 29 1 1918370240 12316320 4197424
19:21:53 82811 8192000000 10841172160 11302264832 1812495760 18.116 93 14 26 1 1826752144 9655712 4600672
19:23:22 44564 8192000000 10883483264 11343130624 1939672560 19.144 100 20 40 0 1956847952 11483424 5691968
19:24:17 44114 8192000000 10837219200 11305435136 1823435024 18.206 94 24 48 0 1846999536 16241568 7322944
19:25:52 23431 8192000000 10871601616 11316289536 1878680816 18.654 97 40 80 3 1897535600 7836752 11018032
19:26:30 38788 8192000000 10516332272 10952224768 1609134928 16.417 84 22 44 1 1625117248 10030656 5951664

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 05-01-2021 19:28:26 to 05-01-2021 19:28:57.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 68 v_add_invoice_to_stock 335544517
except 2 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 05-01-2021 19:28:58 to 05-01-2021 19:29:00.

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          244989
MON$OLDEST_ACTIVE               246270
MON$OLDEST_SNAPSHOT             246270
MON$NEXT_TRANSACTION            246270
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                       2027040
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 ---
:439: 
:440: mscs-test-161.budzdorov.ru    Tue Jan  5 19:27:22 2021
:441:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:442: 
--- end of diff output ---

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

05.01.21 19:29:01. 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 19:29:03 No severe PSQL-related problems occured
05.01.21 19:29:04. End of report.