Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 05.02.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 17012724 kB
MemAvailable 31251872 kB
Buffers 0 kB
Cached 14707492 kB
SwapCached 4876 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-02-05 01:27:16
DTS_END                         2021-02-05 01:27:16.6060
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/39586
TRN_ID                          236296
ATT_ID                          630
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: 9320.78 24310 1118493
customer order: creation 169.48 340 20337
customer order: refuse 14.14 321 1697
order to supplier: creation 45.78 1228 5493
order to supplier: removal 3.37 97995 404
invoice (draft): creation 44.79 3246 5375
invoice (draft): removal 53.55 717 6426
invoice accept: apply 41.32 17458 4958
invoice accept: cancel 48.90 777 5868
customer reserve: creation 3794.84 172 455381
customer reserve: removal 4812.83 54 577540
realization accept: apply 80.60 203 9672
realization accept: cancel 83.95 107 10074
payment from customer: creation 57.93 150 6951
payment from customer: removal 5.73 66 688
payment to supplier: creation 48.97 173 5876
payment to supplier: removal 3.10 79 372
service: total inventory turnovers 4.25 1133 510
service: total monetary turnovers 6.42 28 770
service: aggregate perf. data 0.81 22606 97
service: refresh index statistics 0.03 339338 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 05-02-2021 01:29:05 to 05-02-2021 01:29:07.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4904
TEST_TIME 2 3423
TEST_TIME 3 4375
TEST_TIME 4 4229
TEST_TIME 5 4240
TEST_TIME 6 4290
TEST_TIME 7 4465
TEST_TIME 8 4614
TEST_TIME 9 5100
TEST_TIME 10 5307
TEST_TIME 11 5622
TEST_TIME 12 5839
TEST_TIME 13 6226
TEST_TIME 14 6388
TEST_TIME 15 6588
TEST_TIME 16 6816
TEST_TIME 17 7173
TEST_TIME 18 8036
TEST_TIME 19 8024
TEST_TIME 20 8460
TEST_TIME 21 8614
TEST_TIME 22 8805
TEST_TIME 23 8870
TEST_TIME 24 8883
TEST_TIME 25 9014
TEST_TIME 26 9887
TEST_TIME 27 10032
TEST_TIME 28 10233
TEST_TIME 29 10730
TEST_TIME 30 10765
TEST_TIME 31 10586
TEST_TIME 32 10496
TEST_TIME 33 10485
TEST_TIME 34 10292
TEST_TIME 35 10085
TEST_TIME 36 10110
TEST_TIME 37 10073
TEST_TIME 38 9957
TEST_TIME 39 9839
TEST_TIME 40 9772
TEST_TIME 41 9846
TEST_TIME 42 9808
TEST_TIME 43 9844
TEST_TIME 44 9785
TEST_TIME 45 9705
TEST_TIME 46 9690
TEST_TIME 47 9623
TEST_TIME 48 9624
TEST_TIME 49 9580
TEST_TIME 50 9496
TEST_TIME 51 9411
TEST_TIME 52 9453
TEST_TIME 53 9436
TEST_TIME 54 9393
TEST_TIME 55 9424
TEST_TIME 56 9541
TEST_TIME 57 9531
TEST_TIME 58 9544
TEST_TIME 59 9784
TEST_TIME 60 9802
TEST_TIME 61 9826
TEST_TIME 62 9848
TEST_TIME 63 9938
TEST_TIME 64 9869
TEST_TIME 65 9739
TEST_TIME 66 9673
TEST_TIME 67 9628
TEST_TIME 68 9693
TEST_TIME 69 9612
TEST_TIME 70 9603
TEST_TIME 71 9578
TEST_TIME 72 9605
TEST_TIME 73 9543
TEST_TIME 74 9441
TEST_TIME 75 9429
TEST_TIME 76 9441
TEST_TIME 77 9428
TEST_TIME 78 9438
TEST_TIME 79 9416
TEST_TIME 80 9403
TEST_TIME 81 9461
TEST_TIME 82 9393
TEST_TIME 83 9410
TEST_TIME 84 9471
TEST_TIME 85 9667
TEST_TIME 86 9610
TEST_TIME 87 9629
TEST_TIME 88 9662
TEST_TIME 89 9702
TEST_TIME 90 9761
TEST_TIME 91 9663
TEST_TIME 92 9613
TEST_TIME 93 9565
TEST_TIME 94 9568
TEST_TIME 95 9526
TEST_TIME 96 9518
TEST_TIME 97 9494
TEST_TIME 98 9465
TEST_TIME 99 9452
TEST_TIME 100 9412
TEST_TIME 101 9396
TEST_TIME 102 9374
TEST_TIME 103 9475
TEST_TIME 104 9495
TEST_TIME 105 9442
TEST_TIME 106 9479
TEST_TIME 107 9468
TEST_TIME 108 9528
TEST_TIME 109 9506
TEST_TIME 110 9529
TEST_TIME 111 9543
TEST_TIME 112 9552
TEST_TIME 113 9558
TEST_TIME 114 9487
TEST_TIME 115 9487
TEST_TIME 116 9432
TEST_TIME 117 9410
TEST_TIME 118 9438
TEST_TIME 119 9394
TEST_TIME 120 9323

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 05-02-2021 01:29:09 to 05-02-2021 01:29:12.

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 1540966 1540966 0 0.00 0 21211 6 0 0
doc_list_biud 1540965 1540965 0 0.00 0 31652 26 0 0
sp_add_invoice_to_stock 5163 4958 205 3.97 42 163743 17459 0 205
sp_cancel_adding_invoice 5868 5868 0 0.00 5 73443 777 0 0
sp_cancel_client_order 1697 1697 0 0.00 4 6565 322 0 0
sp_cancel_customer_reserve 577540 577540 0 0.00 1 26765 55 0 0
sp_cancel_pay_from_customer 688 688 0 0.00 2 6630 67 0 0
sp_cancel_pay_to_supplier 372 372 0 0.00 3 4796 79 0 0
sp_cancel_supplier_invoice 6436 6426 10 0.15 2 16045 717 0 10
sp_cancel_supplier_order 404 404 0 0.00 7 1046092 97995 0 0
sp_cancel_write_off 10074 10074 0 0.00 1 22452 107 0 0
sp_client_order 20337 20337 0 0.00 4 24754 341 0 0
sp_customer_reserve 455381 455381 0 0.00 0 71359 172 0 0
sp_fill_shopping_cart 31203 31203 0 0.00 1 15753 42 0 0
sp_fill_shopping_cart_clo_res 455380 455380 0 0.00 0 16446 12 0 0
sp_get_clo_for_invoice 4955 4955 0 0.00 0 21206 291 0 0
sp_kill_cost_storno 17002 17002 0 0.00 0 5573 52 0 0
sp_kill_qstorno_ret_qs2qd 1171984 1171984 0 0.00 0 26751 30 0 0
sp_kill_qty_storno 616635 616635 0 0.00 0 31651 64 0 0
sp_lock_selected_doc 20211 20211 0 0.00 0 8458 5 0 0
sp_make_cost_storno 27454 27454 0 0.00 0 21194 74 0 0
sp_multiply_rows_for_pdistr 27454 27454 0 0.00 0 6814 32 0 0
sp_multiply_rows_for_qdistr 20337 20337 0 0.00 0 15719 153 0 0
sp_pay_from_customer 6951 6951 0 0.00 4 19877 150 0 0
sp_pay_to_supplier 5876 5876 0 0.00 5 19728 174 0 0
sp_payment_common 12827 12827 0 0.00 1 19765 39 0 0
sp_qd_handle_on_cancel_clo 1697 1697 0 0.00 0 6557 295 0 0
sp_qd_handle_on_invoice_upd_sts 10822 10822 0 0.00 0 31650 320 0 0
sp_qd_handle_on_reserve_upd_sts 9672 9672 0 0.00 0 22138 58 0 0
sp_reserve_write_off 9672 9672 0 0.00 6 22216 203 0 0
sp_supplier_invoice 5375 5375 0 0.00 8 80894 3247 0 0
sp_supplier_order 5493 5493 0 0.00 4 54296 1229 0 0
srv_aggregate_perf_data 97 97 0 0.00 2596 422560 22606 0 0
srv_fill_mon_cache_memory 167 167 0 0.00 1138 136077 30799 0 0
srv_find_qd_qs_mism 1071859 1071859 0 0.00 0 14999 5 0 0
srv_make_invnt_saldo 510 510 0 0.00 43 45760 1134 0 0
srv_make_money_saldo 770 770 0 0.00 1 2947 29 0 0
srv_recalc_idx_stat 4 4 0 0.00 245604 463336 339338 0 0
t$perf-abend:sp_add_invoice_to_stock 205 205 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 4959 4959 0 0.00 0 12416 176 0 0
t$perf-norm:sp_cancel_adding_invoice 376 376 0 0.00 0 2830 91 0 0
t$perf-norm:sp_cancel_client_order 1697 1697 0 0.00 0 2648 11 0 0
t$perf-norm:sp_cancel_customer_reserve 685 685 0 0.00 0 1042 9 0 0
t$perf-norm:sp_cancel_pay_from_customer 688 688 0 0.00 0 4652 10 0 0
t$perf-norm:sp_cancel_pay_to_supplier 372 372 0 0.00 0 693 6 0 0
t$perf-norm:sp_cancel_supplier_invoice 397 397 0 0.00 0 711 17 0 0
t$perf-norm:sp_cancel_supplier_order 404 404 0 0.00 0 30580 1742 0 0
t$perf-norm:sp_cancel_write_off 966 966 0 0.00 0 4003 8 0 0
t$perf-norm:sp_client_order 20337 20337 0 0.00 0 9354 20 0 0
t$perf-norm:sp_customer_reserve 1035 1035 0 0.00 0 4018 13 0 0
t$perf-norm:sp_pay_from_customer 6951 6951 0 0.00 0 9238 16 0 0
t$perf-norm:sp_pay_to_supplier 5876 5876 0 0.00 0 8741 13 0 0
t$perf-norm:sp_reserve_write_off 9672 9672 0 0.00 0 9663 12 0 0
t$perf-norm:sp_supplier_invoice 5375 5375 0 0.00 0 5483 19 0 0
t$perf-norm:sp_supplier_order 5493 5493 0 0.00 0 6873 17 0 0
t$perf-norm:srv_aggregate_perf_data 97 97 0 0.00 0 603 18 0 0
t$perf-norm:srv_fill_mon_cache_memory 167 167 0 0.00 0 3072 38 0 0
t$perf-norm:srv_make_invnt_saldo 510 510 0 0.00 0 1034 22 0 0
t$perf-norm:srv_make_money_saldo 770 770 0 0.00 0 1184 21 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 89 24 0 0
v_add_invoice_to_stock 10318 9908 410 3.97 0 10241 24 0 410
v_all_customers 36960 36960 0 0.00 0 45 1 0 0
v_all_suppliers 30352 30352 0 0.00 0 18 1 0 0
v_all_wares 40674 40674 0 0.00 0 97 1 0 0
v_cancel_adding_invoice 752 752 0 0.00 0 412 6 0 0
v_cancel_client_order 3394 3394 0 0.00 0 5646 7 0 0
v_cancel_customer_prepayment 1376 1376 0 0.00 0 137 2 0 0
v_cancel_customer_reserve 1370 1370 0 0.00 0 4358 13 0 0
v_cancel_payment_to_supplier 744 744 0 0.00 0 688 6 0 0
v_cancel_supplier_invoice 814 794 20 2.45 0 3093 21 0 20
v_cancel_supplier_order 808 808 0 0.00 0 613 3 0 0
v_cancel_write_off 1932 1932 0 0.00 0 6878 23 0 0
v_max_id_clo_ord 5493 5493 0 0.00 0 487 1 0 0
v_max_id_clo_res 1035 1035 0 0.00 0 2607 7 0 0
v_max_id_ord_sup 5373 5373 0 0.00 0 4928 4 0 0
v_max_non_paid_invoice 1566 1566 0 0.00 0 8153 8 0 0
v_max_non_paid_realizn 3725 3725 0 0.00 0 6609 10 0 0
v_min_id_clo_ord 5493 5493 0 0.00 0 10022 15 0 0
v_min_id_clo_res 1035 1035 0 0.00 0 6003 12 0 0
v_min_id_ord_sup 5373 5373 0 0.00 0 5177 7 0 0
v_min_non_paid_invoice 5876 5876 0 0.00 0 7316 20 0 0
v_min_non_paid_realizn 6951 6951 0 0.00 0 8986 25 0 0
v_our_firm 10166 10166 0 0.00 0 19 1 0 0
v_reserve_write_off 19344 19344 0 0.00 0 9721 9 0 0
x_lock_depdocs_on_canc_invoice 11897 11897 0 0.00 0 11055 100 0 0
x_lock_depdocs_on_canc_sup_ord 404 404 0 0.00 0 13496 399 0 0
x_make_qstorno_1000_1200 5493 5493 0 0.00 1 54291 1134 0 0
x_make_qstorno_1200_2000 5375 5375 0 0.00 4 80878 3102 0 0
x_make_qstorno_2100_3300 455381 455381 0 0.00 0 71336 157 0 0

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

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:20 18 8192000000 8811007088 8824983552 10584848 0.129 4 1 2 0 10706880 59472 62560
22:57:27 5279 8192000000 10005195728 10266091520 780478064 8.698 63 55 111 0 801281296 2224688 18578544
22:57:40 21260 8192000000 10291496464 10601484288 1334348720 14.006 100 81 162 0 1365024128 4322608 26352800
22:58:12 34594 8192000000 10363710992 10682372096 1411383248 14.696 100 86 172 0 1445810432 6117952 28309232
22:59:00 21109 8192000000 10385825536 10710614016 1439327552 14.944 100 87 174 0 1476037056 7636240 29073264
22:59:31 20520 8192000000 10394539664 10721730560 1453217232 15.066 100 84 168 0 1489552992 8449968 27885792
23:00:02 19409 8192000000 10423390224 10752610304 1478965968 15.292 100 93 186 2 1517531616 8587456 29978192
23:00:37 15403 8192000000 10457423216 10793201664 1514825296 15.605 100 87 174 0 1551607232 9371888 27410048
23:01:02 19494 8192000000 10478848704 10818330624 1529584480 15.733 100 84 168 2 1566330848 10183584 26562784
23:01:35 18212 8192000000 10501627568 10844438528 1553087856 15.937 100 89 179 1 1591453840 10818752 27547232
23:02:18 16241 8192000000 10537436784 10890125312 1577295600 16.145 100 81 159 2 1612663552 11081664 24286288
23:02:42 19597 8192000000 10565880752 10925916160 1620053904 16.510 100 78 156 1 1654993504 11497024 23442576
23:03:10 10084 8192000000 10583104496 10945224704 1645816368 16.729 100 82 164 1 1682061104 11623568 24621168
23:03:27 11843 8192000000 10605317072 10964398080 1658710608 16.838 100 80 160 0 1694473872 12151984 23611280
23:03:49 10231 8192000000 10615451424 10984140800 1673805152 16.965 100 83 166 1 1711109664 12537632 24766880
23:04:06 7981 8192000000 10628303664 10999549952 1685689184 17.065 100 72 144 0 1719005232 12164192 21151856
23:04:27 7982 8192000000 10647541136 11025145856 1715174576 17.312 100 76 149 0 1748980144 11956336 21849232
23:04:46 6682 8192000000 10678950832 11051847680 1737082288 17.494 100 86 173 0 1773565424 11512384 24970752
23:05:00 5423 8192000000 10691060912 11064811520 1746477040 17.572 100 82 164 2 1782508048 12607744 23423264
23:05:13 4737 8192000000 10697525840 11071631360 1758273312 17.670 100 88 174 3 1796356272 13514704 24568256
23:05:25 7460 8192000000 10701880704 11081474048 1765557696 17.730 100 79 157 0 1799588816 12901696 21129424
23:05:40 4723 8192000000 10720889072 11097878528 1776166080 17.818 100 89 178 1 1815279216 14086672 25026464
23:05:53 4486 8192000000 10722464480 11099353088 1783486208 17.878 100 83 166 1 1819695472 13489648 22719616
23:06:04 2855 8192000000 10728412896 11108749312 1789590544 17.928 100 84 168 3 1826391920 14263680 22537696
23:06:15 3702 8192000000 10743996160 11124031488 1798285472 18.000 100 91 182 0 1836659584 13110288 25263824
23:06:25 2326 8192000000 10751037120 11126902784 1805070848 18.055 100 91 183 1 1845069664 14868288 25130528
23:06:34 3374 8192000000 10751790848 11129282560 1805546016 18.059 100 93 185 2 1847070368 16269264 25255088
23:06:45 10710 8192000000 10743870720 11130380288 1808106496 18.080 100 72 144 1 1842038576 13980608 19951472
23:07:03 4538 8192000000 10761979904 11144294400 1817699360 18.159 100 79 158 1 1853966144 14791264 21475520
23:07:14 2413 8192000000 10781734880 11159769088 1833182224 18.285 100 94 188 0 1875096496 15283424 26630848
23:07:23 2077 8192000000 10773285984 11163430912 1838512128 18.329 100 89 178 0 1877238384 13813520 24912736
23:07:32 2255 8192000000 10785664992 11169116160 1844521984 18.378 100 91 183 0 1884768288 14137808 26108496
23:07:41 2334 8192000000 10790257088 11175772160 1847476704 18.402 100 94 188 5 1887827008 14061536 26288768
23:07:50 1978 8192000000 10791259648 11176349696 1849747936 18.420 100 97 192 0 1892334448 15393584 27192928
23:07:58 1355 8192000000 10800136736 11183804416 1853387424 18.450 100 92 184 1 1895123296 15335280 26400592
23:08:07 2321 8192000000 10799724832 11191218176 1859022848 18.495 100 91 178 3 1896982080 12972128 24987104
23:08:16 2482 8192000000 10809169824 11196059648 1861117360 18.512 100 97 195 1 1906515936 18042272 27356304
23:08:25 1450 8192000000 10811018224 11197919232 1863481568 18.531 100 91 184 1 1903491424 13699440 26310416
23:08:32 2096 8192000000 10813543664 11200512000 1868547824 18.573 100 94 189 1 1908419104 13179904 26691376
23:08:42 1210 8192000000 10813651696 11203080192 1870734496 18.590 100 95 190 1 1910778672 12884144 27160032
23:08:49 2342 8192000000 10816053312 11203309568 1870875632 18.591 100 91 182 3 1909346208 12261472 26209104
23:08:57 1159 8192000000 10817041232 11206680576 1877158480 18.642 100 94 188 2 1916086832 12351744 26576608
23:09:05 7400 8192000000 10797368848 11207184384 1873242624 18.611 100 66 132 2 1904755312 11530320 19982368
23:09:25 17228 8192000000 10796021248 11199029248 1869947152 18.584 100 50 99 1 1889092336 4579664 14565520
23:09:49 23571 8192000000 10809702624 11210936320 1875072976 18.625 100 56 112 0 1900601024 9105760 16422288
23:10:19 1589 8192000000 10829116960 11222360064 1884873184 18.704 100 88 176 0 1921325152 11767792 24684176
23:10:27 17204 8192000000 10796934448 11214667776 1876854512 18.640 100 49 96 1 1904049072 14299824 12894736
23:10:50 6806 8192000000 10789357504 11206778880 1875835504 18.631 100 43 86 3 1896766288 7664608 13266176
23:11:03 5141 8192000000 10808704224 11220107264 1884527728 18.702 100 35 72 1 1901415072 6684736 10202608
23:11:15 2570 8192000000 10806085680 11224694784 1888066704 18.730 100 49 98 1 1910940368 8550720 14322944
23:11:26 4368 8192000000 10800838928 11226365952 1886529232 18.718 100 35 71 1 1903040816 6432976 10078608
23:11:37 8674 8192000000 10801532336 11227299840 1885929440 18.713 100 21 42 1 1898017856 6491328 5597088
23:11:54 6314 8192000000 10799654480 11227107328 1890218304 18.748 100 28 57 2 1904804384 6286160 8299920
23:12:06 4630 8192000000 10797049792 11227652096 1892326144 18.765 100 32 62 3 1909067872 6403888 10337840
23:12:19 7201 8192000000 10796730112 11228762112 1891656576 18.759 100 23 46 3 1904417472 6395248 6365648
23:12:33 9249 8192000000 10801701072 11231535104 1892881216 18.769 100 18 35 1 1904042448 6103344 5057888
23:12:49 6969 8192000000 10817607776 11239936000 1894224112 18.780 100 25 51 0 1911551072 10228896 7098064
23:13:03 8747 8192000000 10800861936 11236638720 1895885856 18.793 100 32 64 2 1912075904 7254112 8935936
23:13:23 6424 8192000000 10811192576 11237613568 1896219440 18.796 100 20 40 1 1907125888 5538896 5367552
23:13:38 6459 8192000000 10811525232 11242135552 1897835264 18.809 100 21 42 1 1910780624 7265904 5679456
23:13:55 9427 8192000000 10822298240 11242885120 1904525776 18.863 100 24 46 1 1917683600 5184912 7972912
23:14:11 10898 8192000000 10806832224 11247149056 1906992576 18.882 100 29 58 0 1921568880 5554112 9022192
23:14:29 65145 8192000000 10830232592 11257970688 1894950064 18.786 99 40 80 1 1913227216 5469600 12807552
23:15:42 6305 8192000000 10828026352 11259441152 1910857456 18.914 100 32 63 1 1927063152 7250080 8955616
23:15:56 6436 8192000000 10818665168 11252981760 1892202352 18.764 99 28 56 1 1907161840 7499536 7459952
23:16:11 5841 8192000000 10820860528 11255611392 1905568752 18.871 100 23 46 0 1918587360 6244640 6773968
23:16:23 6963 8192000000 10828079952 11256881152 1909728048 18.904 100 21 41 2 1921349536 5482816 6138672
23:16:38 8579 8192000000 10813879712 11252887552 1894853040 18.785 99 29 58 1 1908697360 5724816 8119504
23:16:54 6880 8192000000 10821401904 11251224576 1895905760 18.793 99 24 48 2 1908465040 6578544 5980736
23:17:12 9848 8192000000 10805792288 11245559808 1892581824 18.767 99 30 60 0 1907002416 5075392 9345200
23:17:28 5056 8192000000 10820974608 11255255040 1907107552 18.883 100 25 49 0 1920497952 6801520 6588880
23:17:43 10901 8192000000 10798407872 11238854656 1870552352 18.589 98 19 37 2 1881180672 5146464 5481856
23:18:01 14501 8192000000 10785362160 11220799488 1827688144 18.240 96 17 34 0 1837511152 5591808 4231200
23:18:23 13016 8192000000 10780911264 11214118912 1841255280 18.351 98 25 50 1 1853802864 5543648 7003936
23:18:48 8000 8192000000 10780530768 11212537856 1870850160 18.591 100 21 42 0 1882301168 5496528 5954480
23:19:02 63455 8192000000 10747910720 11158515712 1757983840 17.668 95 30 60 0 1772502304 5143104 9375360
23:20:12 8550 8192000000 10737000880 11157274624 1801164496 18.023 99 48 97 2 1827315920 12810704 13340720
23:20:27 8840 8192000000 10710792208 11128365056 1726454784 17.406 95 26 52 2 1739505968 5691424 7359760
23:20:42 3303 8192000000 10711196464 11113648128 1727126784 17.412 96 41 79 5 1744322224 5787920 11407520
23:20:54 7159 8192000000 10696545520 11104337920 1742777200 17.542 98 31 62 0 1759315424 6640480 9897744
23:21:07 7852 8192000000 10684526432 11077582848 1728765360 17.425 97 31 62 2 1743750816 6313952 8671504
23:21:22 6765 8192000000 10677920944 11077410816 1709477616 17.264 96 36 73 0 1726319168 6470400 10371152
23:21:35 7148 8192000000 10687918992 11095531520 1703184192 17.212 96 30 60 0 1716894352 5687056 8023104
23:21:51 4415 8192000000 10701373728 11111202816 1775624464 17.813 99 36 72 2 1791262400 5573248 10064688
23:22:04 5668 8192000000 10712660320 11130675200 1798189680 17.999 100 44 87 1 1816962240 6079360 12693200
23:22:18 6696 8192000000 10712580464 11128438784 1782566400 17.871 99 35 69 1 1798898176 6357600 9974176
23:22:31 10280 8192000000 10713469376 11137925120 1793734576 17.962 99 32 64 1 1809111472 5077456 10299440
23:22:49 10716 8192000000 10725003712 11152031744 1803179232 18.040 99 33 65 1 1818185312 5388432 9617648
23:23:06 62087 8192000000 10750766736 11173548032 1833141520 18.285 100 30 60 0 1847430912 5155776 9133616
23:24:15 7843 8192000000 10760938320 11180752896 1837115728 18.317 100 37 73 2 1858905104 11581520 10207856
23:24:32 6402 8192000000 10752573392 11180187648 1842752880 18.363 100 34 68 2 1859890016 6025344 11111792
23:24:46 10583 8192000000 10774136288 11193196544 1846170608 18.391 100 36 73 3 1862519344 6122800 10225936
23:25:05 6828 8192000000 10773140880 11194355712 1852127472 18.439 100 27 54 0 1866887136 7076080 7683584
23:25:18 5756 8192000000 10772451408 11199606784 1855430944 18.466 100 15 30 0 1866444000 5586752 5426304
23:25:33 6616 8192000000 10779518768 11203543040 1859189760 18.497 100 28 56 1 1873479296 6470720 7818816
23:25:46 8439 8192000000 10778358288 11204755456 1866666400 18.557 100 21 42 2 1879111008 5229520 7215088
23:26:02 8079 8192000000 10788832464 11215433728 1869314592 18.579 100 19 37 2 1879469552 5360384 4794576
23:26:16 5379 8192000000 10795349632 11227099136 1877825936 18.648 100 28 56 2 1896650096 11237536 7586624
23:26:28 10725 8192000000 10787506880 11221606400 1876917968 18.640 100 16 32 1 1886739088 5599200 4221920
23:26:45 9138 8192000000 10807705344 11231780864 1881637792 18.678 100 32 64 3 1897444528 6984688 8822048
23:27:05 13563 8192000000 10815990768 11245375488 1892901344 18.769 100 14 28 1 1901808656 5009168 3898144
23:27:26 20958 8192000000 10847052592 11264217088 1916541296 18.959 100 44 85 3 1934767472 5944672 12281504
23:28:07 37927 8192000000 10866129984 11288481792 1928832272 19.058 100 42 84 0 1950837520 10248240 11757008
23:29:22 53389 8192000000 10853515440 11275665408 1919054672 18.979 99 49 96 3 1945023504 11784224 14184608
23:30:23 12550 8192000000 10876182976 11303813120 1940137728 19.148 100 44 88 1 1966209120 13274560 12796832
23:30:43 31874 8192000000 10883952592 11317841920 1952700736 19.248 100 45 90 2 1978629200 12914560 13013904
23:31:30 22053 8192000000 10895273680 11330064384 1957010992 19.282 100 36 68 1 1980245472 13052848 10181632
23:32:00 11284 8192000000 10897940304 11337826304 1967298560 19.364 100 49 95 2 2000410640 19496944 13615136
23:32:27 7763 8192000000 10912503504 11341987840 1972923696 19.409 100 52 103 0 2003044608 15658240 14462672
23:32:42 15854 8192000000 10928224816 11353747456 1980459712 19.468 100 60 120 1 2015450416 18057888 16932816
23:33:30 12891 8192000000 10928133200 11359838208 1985787120 19.510 100 60 120 0 2023570208 20889536 16893552
23:33:56 10097 8192000000 10932922176 11363536896 1986246704 19.514 100 57 113 1 2023425376 21205456 15973216
23:34:16 2647 8192000000 10936630448 11363684352 1986504896 19.516 100 53 106 0 2022006864 20188976 15312992
23:34:34 18230 8192000000 10933681104 11372355584 1997502144 19.603 100 53 106 1 2036795056 23105328 16187584
23:35:01 7075 8192000000 10939691360 11370299392 1977164032 19.442 99 52 103 0 2017011248 24427168 15420048
23:35:19 6221 8192000000 10945826864 11377160192 1993514848 19.572 100 53 102 0 2033489664 25040400 14934416
23:35:33 4402 8192000000 10949957872 11381620736 1996581936 19.596 100 59 118 1 2041322016 27145888 17594192
23:35:48 9012 8192000000 10956082752 11387424768 2001501136 19.635 100 71 140 3 2051157056 28928640 20727280
23:36:12 22243 8192000000 10955485920 11390033920 2003141984 19.648 100 51 102 1 2042264736 24122000 15000752
23:36:45 1686 8192000000 10964488736 11396382720 2009141472 19.695 100 60 120 1 2054119216 26488704 18489040
23:36:55 14708 8192000000 10955833424 11396395008 2006945632 19.677 100 42 84 0 2042446864 22931392 12569840
23:37:26 2586 8192000000 10974205168 11410305024 2018502112 19.768 100 60 121 1 2064860112 27526304 18831696
23:37:41 4401 8192000000 10987239488 11415609344 2021464720 19.792 100 69 136 1 2071143888 28550576 21128592
23:37:56 6992 8192000000 10979800432 11414065152 2022731344 19.802 100 59 118 0 2069622144 29345360 17545440
23:38:10 2826 8192000000 11001716512 11421130752 2027817760 19.842 100 66 132 1 2077333552 28724096 20791696
23:38:21 2305 8192000000 10986631280 11414282240 2009226816 19.695 99 78 156 3 2064575856 31309104 24039936
23:38:31 9882 8192000000 10989079712 11423834112 2023042944 19.804 100 63 126 0 2075075504 32870944 19161616
23:38:48 3757 8192000000 10992507632 11426332672 2026462864 19.831 100 68 133 1 2080310960 32878864 20969232
23:39:03 4392 8192000000 10994736384 11427799040 2027987376 19.843 100 64 128 1 2081227040 33822176 19417488
23:39:14 6685 8192000000 10991931040 11429416960 2027685904 19.840 100 58 116 0 2077981856 31834528 18461424
23:39:33 6655 8192000000 10987160768 11422453760 2025101680 19.820 100 57 114 0 2074473280 32220992 17150608
23:39:50 5826 8192000000 10995018144 11418894336 2019344976 19.775 100 77 154 0 2074694448 31142752 24206720
23:40:03 3023 8192000000 10991641728 11422801920 2022266928 19.798 100 68 134 2 2075462800 31942304 21253568
23:40:19 2597 8192000000 10980211744 11409096704 2015338224 19.744 100 70 138 1 2066178672 30349024 20491424
23:40:28 3256 8192000000 10970727648 11396194304 1996558016 19.596 99 81 160 1 2049710304 29764304 23387984
23:40:39 1701 8192000000 10983709248 11398483968 2003463552 19.650 100 85 169 0 2060053328 30453184 26136592
23:40:48 3421 8192000000 10962846272 11387486208 1992831760 19.566 100 79 157 1 2047440768 31191040 23417968
23:40:58 3590 8192000000 10973182352 11397128192 2001496064 19.635 100 76 152 2 2056804336 32458848 22849424
23:41:10 6048 8192000000 10973892960 11406405632 2010368032 19.704 100 71 140 2 2065495600 34638448 20489120
23:41:25 2350 8192000000 10992388032 11416342528 2016050560 19.749 100 87 174 0 2077745472 35186784 26508128
23:41:34 1960 8192000000 10999856256 11419533312 2017719808 19.762 100 89 176 0 2080333504 35597312 27016384
23:41:44 1136 8192000000 11005231696 11420188672 2021178848 19.789 100 92 183 2 2084974544 36275984 27519712
23:41:52 2915 8192000000 10993233680 11417149440 2014042512 19.733 100 81 162 1 2076316832 37850576 24423744
23:42:03 10628 8192000000 10968469232 11397091328 1993729184 19.573 100 79 158 4 2057374576 39091280 24554112
23:42:22 4601 8192000000 10983519360 11412209664 2005850576 19.669 100 70 139 0 2070106656 42735168 21520912
23:42:36 6914 8192000000 10969925984 11398320128 1978395056 19.452 99 65 130 1 2042610448 43754528 20460864
23:42:58 7879 8192000000 10968767040 11400609792 1977853808 19.448 99 68 134 1 2044192656 44208352 22130496
23:43:15 3249 8192000000 10980513648 11409055744 1994759280 19.581 100 69 136 2 2059399040 43547552 21092208
23:43:32 1872 8192000000 10987248864 11399434240 1979109952 19.458 99 89 177 2 2051914352 45247488 27556912
23:43:41 2890 8192000000 11000911072 11420467200 2004159968 19.656 100 86 171 2 2079187152 48253504 26773680
23:43:52 12122 8192000000 10983027968 11405852672 1986029888 19.512 99 69 138 0 2056799824 48439264 22330672
23:44:11 4105 8192000000 10954709168 11378786304 1964408608 19.341 99 70 139 2 2037360784 49605840 23346336
23:44:23 4820 8192000000 10976005408 11403984896 1988618336 19.533 100 74 149 1 2062944576 50670512 23655728
23:44:36 5478 8192000000 10978628016 11407368192 1992965264 19.567 100 76 149 4 2066024304 49319408 23739632
23:44:48 3727 8192000000 10978352576 11411955712 1994690224 19.581 100 69 137 1 2068039568 51542112 21807232
23:45:00 2050 8192000000 10969950656 11393003520 1966653056 19.359 99 82 164 0 2039955552 47460480 25842016
23:45:09 3650 8192000000 10956755840 11381940224 1964702112 19.343 100 75 150 0 2037078512 48195792 24180608
23:45:24 3470 8192000000 10953102544 11376705536 1955008464 19.266 99 69 138 0 2024351648 47035840 22307344
23:45:35 4047 8192000000 10948418560 11377434624 1965471168 19.350 100 59 116 2 2029052544 43957472 19623904
23:45:46 2496 8192000000 10918715152 11349979136 1947537936 19.207 100 78 155 2 2013279728 40805072 24936720
23:45:55 2012 8192000000 10903189184 11328282624 1932436336 19.086 99 62 122 0 1988936000 37490544 19009120
23:46:08 3246 8192000000 10932108208 11360395264 1955969840 19.274 100 62 124 1 2014703616 38920272 19813504
23:46:18 8594 8192000000 10923694224 11354869760 1941086624 19.155 99 61 121 1 1998634656 38129392 19418640
23:46:34 3546 8192000000 10928237008 11352391680 1950571648 19.231 100 67 133 4 2009107552 38100544 20435360
23:46:44 4745 8192000000 10933182992 11358330880 1955161504 19.268 100 73 147 1 2018301248 39859824 23279920
23:46:55 3880 8192000000 10931874992 11358203904 1956342288 19.277 100 63 126 0 2017286880 41386592 19558000
23:47:10 2405 8192000000 10934382672 11367403520 1956637728 19.279 100 57 114 0 2017520432 42677632 18205072
23:47:19 18348 8192000000 10912869840 11360538624 1939574304 19.143 99 34 68 4 1991870592 40737952 11558336
23:47:53 10095 8192000000 10915461584 11357618176 1939874400 19.146 99 31 62 0 1987606272 36948208 10783664
23:48:10 23232 8192000000 10903553808 11355889664 1947225024 19.204 100 30 60 2 1991359248 34984640 9149584
23:48:39 21982 8192000000 10896020880 11340091392 1893548400 18.774 97 26 50 1 1938219056 36456688 8213968
23:49:12 13530 8192000000 10910603984 11354836992 1933728064 19.097 99 29 58 1 1978464144 35822064 8914016
23:49:32 14745 8192000000 10901346240 11353735168 1931620800 19.080 99 28 56 2 1978754784 38513632 8620352
23:50:00 10465 8192000000 10914023008 11358666752 1941717280 19.160 100 40 80 2 1998161728 43762976 12681472
23:50:17 16988 8192000000 10891411840 11335131136 1928903312 19.058 100 21 42 1 1971699328 35880608 6915408
23:50:44 16034 8192000000 10905927552 11353948160 1938635712 19.136 100 43 85 0 1992647616 40048864 13963040
23:51:12 29920 8192000000 10883533696 11334180864 1881939840 18.681 97 26 51 1 1941257408 50236560 9081008
23:51:48 12250 8192000000 10916191520 11348733952 1912001824 18.923 99 39 78 3 1978468096 53358880 13107392
23:52:07 10403 8192000000 10914187952 11354345472 1935953456 19.114 100 41 80 2 2003594064 54476752 13163856
23:52:28 6640 8192000000 10920285904 11355328512 1925666128 19.032 100 43 87 1 1998424112 58668608 14089376
23:52:44 9627 8192000000 10921255456 11364233216 1921823664 19.001 99 49 98 2 1995423040 57404784 16194592
23:52:59 10192 8192000000 10932421456 11376918528 1938575520 19.135 100 38 76 0 2010871376 59471648 12824208
23:53:17 8790 8192000000 10914984208 11358171136 1923783376 19.017 99 39 78 1 1987912304 50891680 13237248
23:53:40 19964 8192000000 10910653392 11367518208 1948350352 19.213 100 29 58 0 2000769920 42619328 9800240
23:54:07 18440 8192000000 10904867936 11352862720 1958253472 19.292 100 25 50 0 1996636912 30647408 7736032
23:54:32 23785 8192000000 10893710624 11350970368 1938646448 19.136 99 24 47 3 1971117296 25101024 7369824
23:55:58 72735 8192000000 10852896096 11318824960 1885332096 18.708 97 13 26 0 1921260032 31526624 4401312
23:57:18 65679 8192000000 10861330608 11309498368 1847020592 18.398 95 12 23 0 1861680080 11147808 3511680
23:58:36 48111 8192000000 10872596256 11318222848 1907543152 18.887 98 30 60 0 1927028976 11695136 7790688
23:59:30 21694 8192000000 10868114608 11313344512 1937025648 19.123 100 35 68 1 1951433184 5843040 8564496
00:00:00 12527 8192000000 10871157488 11314536448 1924616240 19.024 99 17 34 1 1936430304 7306256 4507808
00:00:37 106420 8192000000 10867486544 11322908672 1903182864 18.852 98 14 28 2 1921421200 14514592 3723744
00:02:30 93158 8192000000 10887329248 11348586496 1931486016 19.079 99 36 71 1 1957524944 16070688 9968240
00:04:09 44379 8192000000 10881683072 11349274624 1948609792 19.215 100 19 38 0 1971593872 17437552 5546528
00:05:02 36772 8192000000 10888968768 11344490496 1939579232 19.143 99 26 52 0 1956300560 9711280 7010048
00:05:45 45876 8192000000 10861996288 11319660544 1899946672 18.826 97 28 56 0 1916724400 9249440 7528288
00:06:38 43642 8192000000 10899634224 11353767936 1965328656 19.348 100 53 106 1 1993485056 12553376 15603024
00:07:29 92659 8192000000 10885741680 11360251904 1939912960 19.146 99 18 35 2 1959689856 14492848 5284048
00:09:08 34939 8192000000 10885635376 11365388288 1960055184 19.306 100 10 20 0 1981223232 17143984 4024064
00:10:40 51857 8192000000 10871410896 11339649024 1943127824 19.172 99 13 26 0 1957524688 10966704 3430160
00:11:39 36365 8192000000 10884854624 11358441472 1958992256 19.298 100 11 22 0 1976860976 14945920 2922800
00:12:28 48770 8192000000 10882174496 11359944704 1943644208 19.176 99 14 28 0 1961221952 13398320 4179424
00:13:23 41171 8192000000 10884035232 11371720704 1959020848 19.298 100 9 18 0 1972611104 11048576 2541680
00:14:10 31941 8192000000 10888712192 11379937280 1967587200 19.366 100 13 26 1 1985965760 15026144 3352416
00:14:50 3264 8192000000 10890439376 11380408320 1967136016 19.363 100 8 16 1 1984333632 14888784 2308832
00:15:01 24440 8192000000 10907878768 11383701504 1972356128 19.404 100 10 20 1 1991185808 15485200 3344480
00:15:40 79098 8192000000 10897458720 11377369088 1941746304 19.161 98 23 46 0 1956694544 8728768 6219472
00:17:06 70751 8192000000 10911244912 11384958976 1980197536 19.466 100 13 26 0 2000262848 16823408 3241904
00:18:25 32934 8192000000 10933361504 11393339392 1987965856 19.528 100 30 60 0 2009238720 13204240 8068624
00:19:06 26630 8192000000 10908550912 11379458048 1970410912 19.389 99 28 55 0 1993289120 14942368 7935840
00:19:40 57530 8192000000 10917476624 11402371072 1969738000 19.383 99 23 46 1 1988546928 12276560 6532368
00:20:44 71629 8192000000 10947013904 11413463040 1992131616 19.561 100 15 30 0 2009261920 12902544 4227760
00:22:05 50804 8192000000 10929797440 11400347648 1961550752 19.318 98 19 38 2 1988214944 20737808 5926384
00:23:12 70608 8192000000 10935783888 11410292736 1989338352 19.539 100 12 24 0 2009866896 16864080 3664464
00:24:39 73685 8192000000 10940163744 11416522752 1980604976 19.469 99 18 36 2 2003828304 17812528 5410800
00:26:01 54220 8192000000 10888341520 11377815552 1929191504 19.060 97 12 25 1 1955666240 22754000 3720736
00:27:12 40663 8192000000 10889919552 11363241984 1897778288 18.808 96 16 32 1 1916772448 14979744 4014416
00:28:00 86490 8192000000 10892593648 11374166016 1925060768 19.027 98 14 28 0 1940930096 12613456 3255872
00:29:33 71002 8192000000 10905994192 11385970688 1934734352 19.105 98 7 14 0 1948769760 12458384 1577024
00:30:50 76219 8192000000 10891662448 11350097920 1866845248 18.559 94 24 48 2 1881746128 7426816 7474064
00:33:29 55239 8192000000 10876603184 11336601600 1937685712 19.128 99 42 85 0 1962056928 12770336 11600880
00:34:44 27551 8192000000 10884453440 11349303296 1932436464 19.086 99 37 75 1 1960104080 17541552 10126064
00:35:18 17110 8192000000 10885096800 11359862784 1951376016 19.237 100 23 46 0 1977893072 20286608 6230448
00:35:44 3971 8192000000 10868551888 11350396928 1942899424 19.170 100 9 18 2 1960426576 14997648 2529504
00:35:59 2364 8192000000 10864344944 11358023680 1947470800 19.206 100 3 6 0 1959647360 11488592 687968
00:36:31 59732 8192000000 10876155312 11353812992 1952040368 19.243 100 23 45 1 1968485168 10110272 6334528
00:37:37 59091 8192000000 10856273312 11336634368 1896657440 18.799 97 13 26 1 1912404096 12211760 3534896
00:39:43 40786 8192000000 10799615616 11260608512 1830165920 18.261 95 20 37 2 1848039904 12786736 5087248
00:40:32 65274 8192000000 10823348736 11289313280 1870743264 18.590 98 18 36 1 1887192272 11503664 4945344
00:42:02 52622 8192000000 10824461744 11298820096 1886353520 18.716 99 8 16 0 1905850496 17243696 2253280
00:43:05 52842 8192000000 10827486048 11315941376 1860622016 18.508 97 11 22 0 1877758048 13951120 3184912
00:44:04 32601 8192000000 10819857344 11284131840 1833897440 18.291 96 12 24 0 1853156720 15621168 3638112
00:44:53 50612 8192000000 10823717328 11296960512 1873541952 18.613 98 8 16 1 1884098928 8538192 2018784
00:45:53 61611 8192000000 10853831344 11312001024 1880847504 18.672 98 25 51 3 1898740688 10988048 6905136
00:47:01 41862 8192000000 10860530016 11320639488 1925764272 19.033 100 30 60 0 1945689824 11335568 8589984
00:47:49 45599 8192000000 10843647776 11315462144 1890450832 18.749 98 23 46 0 1909480304 11980624 7048848
00:48:48 87739 8192000000 10859140000 11322236928 1878902320 18.656 97 24 48 0 1896073776 10175600 6995856
00:50:23 37693 8192000000 10844424128 11301507072 1855322512 18.465 96 27 53 1 1876583488 12953680 8307296
00:51:24 58784 8192000000 10859718064 11333963776 1891343120 18.757 98 19 38 1 1919475120 23202448 4929552
00:52:38 51763 8192000000 10859101520 11326042112 1880133712 18.666 98 9 18 0 1914836848 31495648 3207488
00:53:43 53638 8192000000 10870696112 11333672960 1913542256 18.935 99 25 50 2 1933945008 13410560 6992192
00:54:48 22300 8192000000 10889597440 11335086080 1934480416 19.103 100 41 82 3 1960446192 14702032 11263744
00:55:24 28179 8192000000 10879480224 11334782976 1907058608 18.883 98 33 66 1 1932914992 16503584 9352800
00:55:59 64832 8192000000 10879666480 11348357120 1872718208 18.606 97 16 32 0 1903708400 26629584 4360608
00:57:13 136064 8192000000 10847290624 11311935488 1895682240 18.792 98 17 33 2 1922817776 22220368 4915168
00:59:39 68874 8192000000 10874395968 11338428416 1924895968 19.026 99 21 40 3 1943988768 13873584 5219216
01:00:54 51233 8192000000 10886088624 11357052928 1955136336 19.267 100 24 48 0 1970968384 9637520 6194528
01:02:59 28730 8192000000 10883276848 11354300416 1961088240 19.315 100 13 26 0 1973139584 8470816 3580528
01:03:34 71121 8192000000 10878295088 11357618176 1928987648 19.059 98 13 26 0 1938039392 5993664 3058080
01:04:51 56737 8192000000 10871789024 11344035840 1940596192 19.152 99 5 11 0 1949403088 7686192 1120704
01:06:05 59401 8192000000 10872810912 11350958080 1924702896 19.025 98 10 19 2 1936010000 8750512 2556592
01:07:10 34718 8192000000 10909179808 11361644544 1939315856 19.141 99 20 40 0 1953055280 7872112 5867312
01:07:56 39913 8192000000 10900046928 11358339072 1953676784 19.256 99 36 72 1 1976211568 12336176 10198608
01:08:42 55451 8192000000 10906897296 11377074176 1970380176 19.388 100 16 32 0 1988291632 12935200 4976256
01:10:28 80595 8192000000 10903177344 11387973632 1953702576 19.256 99 10 20 0 1976669904 19806224 3161104
01:11:58 56612 8192000000 10918207808 11389657088 1978771344 19.455 100 14 27 1 1998703744 16109456 3822944
01:13:06 90320 8192000000 10915260208 11391299584 1946242368 19.197 98 14 28 0 1961348112 10920528 4185216
01:14:42 84180 8192000000 10904418880 11397517312 1951585248 19.239 98 20 40 2 1973323520 16072688 5665584
01:16:13 134626 8192000000 10895294240 11381379072 1901774544 18.841 96 15 30 0 1922924688 17885552 3264592
01:18:33 69900 8192000000 10900159872 11383963648 1949750832 19.224 99 5 10 0 1961588784 10559280 1278672
01:19:49 31304 8192000000 10893887392 11366952960 1938119520 19.132 98 15 30 0 1950817008 8728208 3969280
01:21:54 74440 8192000000 10860677152 11334041600 1844868352 18.380 94 17 34 1 1858584320 9294304 4421664
01:23:16 47280 8192000000 10883731376 11338752000 1931440832 19.078 99 42 82 0 1951466096 8735568 11289696
01:24:21 37736 8192000000 10843235696 11309875200 1900457408 18.830 98 25 50 1 1918335344 11123504 6754432
01:25:20 54271 8192000000 10849234896 11340156928 1915723712 18.953 99 10 20 0 1931898960 13052416 3122832
01:26:21 20673 8192000000 10849884784 11336355840 1916412832 18.958 99 9 17 0 1928768592 10042048 2313712
01:26:47 34008 8192000000 9571171584 9897795584 712043984 7.996 37 5 10 0 720955536 7346656 1564896

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-02-2021 01:29:19 to 05-02-2021 01:29:51.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 205 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-02-2021 01:29:52 to 05-02-2021 01:29:54.

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          236295
MON$OLDEST_ACTIVE               236659
MON$OLDEST_SNAPSHOT             236659
MON$NEXT_TRANSACTION            236659
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                       2045728
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.33413 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33413 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33413 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33413 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 ---
:45: 
:46: mscs-test-161.budzdorov.ru    Fri Feb  5 01:27:39 2021
:47:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:48: 
--- end of diff output ---

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

05.02.21 01:29:55. 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-02-05 01:29:57 No severe PSQL-related problems occured
05.02.21 01:29:59. End of report.