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

Hardware and OS info

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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-03-09 22:27:20
DTS_END                         2021-03-09 22:27:20.3600
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_ORDER(38:5) ==> X_MAKE_QSTORNO_1000_1200(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/56334
TRN_ID                          239679
ATT_ID                          646
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: 9400.23 24179 1128027
customer order: creation 168.38 390 20206
customer order: refuse 14.42 372 1730
order to supplier: creation 45.53 1338 5464
order to supplier: removal 3.48 106818 417
invoice (draft): creation 45.97 3488 5516
invoice (draft): removal 55.85 840 6702
invoice accept: apply 40.63 18479 4875
invoice accept: cancel 50.30 842 6036
customer reserve: creation 3741.99 183 449039
customer reserve: removal 4935.98 58 592318
realization accept: apply 84.39 178 10127
realization accept: cancel 85.01 115 10201
payment from customer: creation 58.88 132 7065
payment from customer: removal 5.56 87 667
payment to supplier: creation 48.24 173 5789
payment to supplier: removal 3.29 85 395
service: total inventory turnovers 4.95 989 594
service: total monetary turnovers 6.46 29 775
service: aggregate perf. data 0.89 17835 107
service: refresh index statistics 0.03 331154 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 09-03-2021 22:29:32 to 09-03-2021 22:29:34.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4162
TEST_TIME 2 4492
TEST_TIME 3 5309
TEST_TIME 4 5755
TEST_TIME 5 5451
TEST_TIME 6 5896
TEST_TIME 7 5930
TEST_TIME 8 6186
TEST_TIME 9 6047
TEST_TIME 10 5876
TEST_TIME 11 6237
TEST_TIME 12 6467
TEST_TIME 13 6527
TEST_TIME 14 6646
TEST_TIME 15 7014
TEST_TIME 16 7029
TEST_TIME 17 7405
TEST_TIME 18 7668
TEST_TIME 19 8014
TEST_TIME 20 8510
TEST_TIME 21 8658
TEST_TIME 22 9048
TEST_TIME 23 9074
TEST_TIME 24 9431
TEST_TIME 25 9880
TEST_TIME 26 10574
TEST_TIME 27 11002
TEST_TIME 28 11038
TEST_TIME 29 10932
TEST_TIME 30 10654
TEST_TIME 31 10623
TEST_TIME 32 10630
TEST_TIME 33 10806
TEST_TIME 34 10874
TEST_TIME 35 10605
TEST_TIME 36 10421
TEST_TIME 37 10327
TEST_TIME 38 10170
TEST_TIME 39 10112
TEST_TIME 40 10085
TEST_TIME 41 10031
TEST_TIME 42 10096
TEST_TIME 43 10062
TEST_TIME 44 9925
TEST_TIME 45 9915
TEST_TIME 46 9980
TEST_TIME 47 9957
TEST_TIME 48 9837
TEST_TIME 49 9841
TEST_TIME 50 9717
TEST_TIME 51 9662
TEST_TIME 52 9581
TEST_TIME 53 9581
TEST_TIME 54 9526
TEST_TIME 55 9464
TEST_TIME 56 9437
TEST_TIME 57 9487
TEST_TIME 58 9584
TEST_TIME 59 9589
TEST_TIME 60 9572
TEST_TIME 61 9775
TEST_TIME 62 9720
TEST_TIME 63 9810
TEST_TIME 64 9850
TEST_TIME 65 9937
TEST_TIME 66 9953
TEST_TIME 67 9876
TEST_TIME 68 9772
TEST_TIME 69 9852
TEST_TIME 70 9765
TEST_TIME 71 9730
TEST_TIME 72 9627
TEST_TIME 73 9635
TEST_TIME 74 9547
TEST_TIME 75 9608
TEST_TIME 76 9616
TEST_TIME 77 9660
TEST_TIME 78 9666
TEST_TIME 79 9658
TEST_TIME 80 9707
TEST_TIME 81 9750
TEST_TIME 82 9752
TEST_TIME 83 9755
TEST_TIME 84 9724
TEST_TIME 85 9809
TEST_TIME 86 9787
TEST_TIME 87 9809
TEST_TIME 88 9728
TEST_TIME 89 9675
TEST_TIME 90 9616
TEST_TIME 91 9577
TEST_TIME 92 9639
TEST_TIME 93 9611
TEST_TIME 94 9586
TEST_TIME 95 9563
TEST_TIME 96 9550
TEST_TIME 97 9583
TEST_TIME 98 9567
TEST_TIME 99 9581
TEST_TIME 100 9588
TEST_TIME 101 9667
TEST_TIME 102 9687
TEST_TIME 103 9655
TEST_TIME 104 9676
TEST_TIME 105 9687
TEST_TIME 106 9681
TEST_TIME 107 9697
TEST_TIME 108 9734
TEST_TIME 109 9799
TEST_TIME 110 9732
TEST_TIME 111 9659
TEST_TIME 112 9643
TEST_TIME 113 9595
TEST_TIME 114 9605
TEST_TIME 115 9614
TEST_TIME 116 9589
TEST_TIME 117 9548
TEST_TIME 118 9519
TEST_TIME 119 9479
TEST_TIME 120 9407

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 09-03-2021 22:29:36 to 09-03-2021 22:29:39.

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 1545524 1545524 0 0.00 0 35185 6 0 0
doc_list_biud 1545524 1545524 0 0.00 0 60527 29 0 0
sp_add_invoice_to_stock 5000 4875 125 2.50 43 145842 18479 0 125
sp_cancel_adding_invoice 6036 6036 0 0.00 5 71586 842 0 0
sp_cancel_client_order 1730 1730 0 0.00 4 24465 373 0 0
sp_cancel_customer_reserve 592318 592318 0 0.00 1 60535 59 0 0
sp_cancel_pay_from_customer 667 667 0 0.00 3 6606 88 0 0
sp_cancel_pay_to_supplier 395 395 0 0.00 3 7522 85 0 0
sp_cancel_supplier_invoice 6711 6702 9 0.13 1 19889 841 0 9
sp_cancel_supplier_order 417 417 0 0.00 18 1023327 106818 0 0
sp_cancel_write_off 10201 10201 0 0.00 1 29146 116 0 0
sp_client_order 20206 20206 0 0.00 4 35271 390 0 0
sp_customer_reserve 449039 449039 0 0.00 0 43939 183 0 0
sp_fill_shopping_cart 31172 31172 0 0.00 1 15917 37 0 0
sp_fill_shopping_cart_clo_res 449017 449017 0 0.00 0 14607 13 0 0
sp_get_clo_for_invoice 4853 4853 0 0.00 0 20221 312 0 0
sp_kill_cost_storno 17299 17299 0 0.00 0 29144 57 0 0
sp_kill_qstorno_ret_qs2qd 1201956 1201956 0 0.00 0 60515 32 0 0
sp_kill_qty_storno 632384 632384 0 0.00 0 60526 70 0 0
sp_lock_selected_doc 20697 20697 0 0.00 0 6497 6 0 0
sp_make_cost_storno 27834 27834 0 0.00 0 21211 57 0 0
sp_multiply_rows_for_pdistr 27834 27834 0 0.00 0 13416 32 0 0
sp_multiply_rows_for_qdistr 20206 20206 0 0.00 0 21570 177 0 0
sp_pay_from_customer 7065 7065 0 0.00 4 13861 133 0 0
sp_pay_to_supplier 5789 5789 0 0.00 4 26826 173 0 0
sp_payment_common 12854 12854 0 0.00 1 13215 28 0 0
sp_qd_handle_on_cancel_clo 1730 1730 0 0.00 0 24460 347 0 0
sp_qd_handle_on_invoice_upd_sts 10889 10889 0 0.00 0 49299 350 0 0
sp_qd_handle_on_reserve_upd_sts 10127 10127 0 0.00 0 20528 58 0 0
sp_reserve_write_off 10127 10127 0 0.00 6 22217 179 0 0
sp_supplier_invoice 5516 5516 0 0.00 6 105050 3489 0 0
sp_supplier_order 5464 5464 0 0.00 5 37093 1339 0 0
srv_aggregate_perf_data 107 107 0 0.00 3290 147427 17836 0 0
srv_fill_mon_cache_memory 163 163 0 0.00 1497 114861 32159 0 0
srv_find_qd_qs_mism 1082004 1082004 0 0.00 0 26355 5 0 0
srv_make_invnt_saldo 594 594 0 0.00 42 55079 990 0 0
srv_make_money_saldo 775 775 0 0.00 1 2727 30 0 0
srv_recalc_idx_stat 4 4 0 0.00 181541 493104 331155 0 0
t$perf-abend:sp_add_invoice_to_stock 125 125 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4875 4875 0 0.00 0 10500 195 0 0
t$perf-norm:sp_cancel_adding_invoice 402 402 0 0.00 0 21302 151 0 0
t$perf-norm:sp_cancel_client_order 1730 1730 0 0.00 0 5708 28 0 0
t$perf-norm:sp_cancel_customer_reserve 681 681 0 0.00 0 1171 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 667 667 0 0.00 0 1028 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 395 395 0 0.00 0 6851 28 0 0
t$perf-norm:sp_cancel_supplier_invoice 381 381 0 0.00 0 646 16 0 0
t$perf-norm:sp_cancel_supplier_order 417 417 0 0.00 0 36240 1706 0 0
t$perf-norm:sp_cancel_write_off 1044 1044 0 0.00 0 5640 22 0 0
t$perf-norm:sp_client_order 20206 20206 0 0.00 0 5598 20 0 0
t$perf-norm:sp_customer_reserve 1020 1020 0 0.00 0 3955 9 0 0
t$perf-norm:sp_pay_from_customer 7065 7065 0 0.00 0 5632 12 0 0
t$perf-norm:sp_pay_to_supplier 5789 5789 0 0.00 0 5750 13 0 0
t$perf-norm:sp_reserve_write_off 10127 10127 0 0.00 0 21271 19 0 0
t$perf-norm:sp_supplier_invoice 5516 5516 0 0.00 0 5627 23 0 0
t$perf-norm:sp_supplier_order 5464 5464 0 0.00 0 5424 18 0 0
t$perf-norm:srv_aggregate_perf_data 107 107 0 0.00 0 218 7 0 0
t$perf-norm:srv_fill_mon_cache_memory 163 163 0 0.00 0 130 3 0 0
t$perf-norm:srv_make_invnt_saldo 594 594 0 0.00 0 2075 26 0 0
t$perf-norm:srv_make_money_saldo 775 775 0 0.00 0 1965 16 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 6 3 0 0
v_add_invoice_to_stock 9956 9706 250 2.51 0 6081 19 0 250
v_all_customers 36724 36724 0 0.00 0 24 1 0 0
v_all_suppliers 30486 30486 0 0.00 0 25 1 0 0
v_all_wares 40412 40412 0 0.00 0 19 1 0 0
v_cancel_adding_invoice 804 804 0 0.00 0 340 6 0 0
v_cancel_client_order 3460 3460 0 0.00 0 6301 7 0 0
v_cancel_customer_prepayment 1334 1334 0 0.00 0 6039 13 0 0
v_cancel_customer_reserve 1362 1362 0 0.00 0 653 4 0 0
v_cancel_payment_to_supplier 790 790 0 0.00 0 7512 20 0 0
v_cancel_supplier_invoice 780 762 18 2.30 0 7127 24 0 18
v_cancel_supplier_order 834 834 0 0.00 0 5549 21 0 0
v_cancel_write_off 2088 2088 0 0.00 0 4102 16 0 0
v_max_id_clo_ord 5461 5461 0 0.00 0 5237 3 0 0
v_max_id_clo_res 1020 1020 0 0.00 0 3527 25 0 0
v_max_id_ord_sup 5505 5505 0 0.00 0 6209 4 0 0
v_max_non_paid_invoice 1509 1509 0 0.00 0 1432 3 0 0
v_max_non_paid_realizn 3802 3802 0 0.00 0 2948 5 0 0
v_min_id_clo_ord 5461 5461 0 0.00 0 3098 7 0 0
v_min_id_clo_res 1020 1020 0 0.00 0 5557 14 0 0
v_min_id_ord_sup 5505 5505 0 0.00 0 9672 11 0 0
v_min_non_paid_invoice 5789 5789 0 0.00 0 11017 18 0 0
v_min_non_paid_realizn 7065 7065 0 0.00 0 9713 17 0 0
v_our_firm 10214 10214 0 0.00 0 21 1 0 0
v_reserve_write_off 20254 20254 0 0.00 0 22153 9 0 0
x_lock_depdocs_on_canc_invoice 12357 12357 0 0.00 0 16090 114 0 0
x_lock_depdocs_on_canc_sup_ord 417 417 0 0.00 0 35138 442 0 0
x_make_qstorno_1000_1200 5464 5464 0 0.00 2 37081 1256 0 0
x_make_qstorno_1200_2000 5516 5516 0 0.00 2 105027 3361 0 0
x_make_qstorno_2100_3300 449039 449039 0 0.00 0 41213 168 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 09-03-2021 22:29:40 to 09-03-2021 22:29:44.

Memory consumption, metadata cache, attachments activity

Fields:
  page cache memo used            = page cache total size, bytes:
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = metadata cache, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000                                                                                                                                                                     

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
19:57:24 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:30 18610 8192000000 10238979520 10546044928 998964448 10.868 80 54 108 0 1019899888 2679984 18255456
19:57:57 29816 8192000000 10356150704 10670804992 1383635664 14.449 100 88 176 0 1415965200 4215920 28113616
19:58:39 38557 8192000000 10395223952 10719064064 1441731296 14.965 100 90 180 1 1477536208 6514416 29290496
19:59:28 24146 8192000000 10418211504 10746265600 1463757856 15.159 100 83 166 2 1498502320 7635888 27108576
20:00:07 22589 8192000000 10454239552 10787594240 1503190368 15.504 100 88 176 0 1539899696 8565456 28143872
20:00:38 25771 8192000000 10467032944 10804154368 1523316896 15.679 100 90 180 0 1561094896 9438176 28339824
20:01:26 28935 8192000000 10493565344 10842140672 1545040992 15.867 100 74 148 1 1578039888 9862288 23136608
20:02:04 17082 8192000000 10529775952 10876882944 1583966128 16.202 100 86 172 0 1621017856 10743056 26308672
20:02:31 14496 8192000000 10528631024 10886742016 1593086800 16.280 100 72 144 0 1625623600 10909072 21627728
20:02:54 12463 8192000000 10562748448 10919829504 1609594160 16.421 100 73 146 3 1642500704 10704816 22201728
20:03:16 11988 8192000000 10585069360 10948231168 1644780784 16.720 100 75 150 2 1678063520 11404080 21878656
20:03:35 9407 8192000000 10604843136 10970042368 1664423104 16.886 100 79 158 0 1698558896 10860512 23275280
20:03:57 9290 8192000000 10622978416 10995970048 1689883952 17.100 100 73 144 0 1721725728 11373024 20468752
20:04:14 8412 8192000000 10658342704 11029524480 1709450160 17.264 100 72 144 1 1741330768 11137056 20743552
20:04:31 4489 8192000000 10668118608 11044777984 1727709568 17.416 100 73 146 0 1760540864 12058304 20772992
20:04:43 7629 8192000000 10686086688 11059810304 1742491680 17.539 100 75 150 0 1776181120 12174240 21515200
20:04:59 4400 8192000000 10693309024 11070353408 1758986912 17.676 100 70 140 1 1791069728 12391248 19691568
20:05:11 5881 8192000000 10716963664 11096768512 1771385520 17.778 100 77 154 0 1806223392 13249472 21588400
20:05:24 5503 8192000000 10714170640 11099586560 1780125200 17.851 100 84 167 0 1817184432 13421984 23637248
20:05:39 4447 8192000000 10723671072 11108884480 1787016288 17.907 100 76 151 1 1820453232 12988416 20448528
20:05:50 4125 8192000000 10732422064 11116601344 1798609536 18.003 100 78 157 0 1833629072 13060896 21958640
20:06:02 7415 8192000000 10738281184 11127775232 1799727920 18.012 100 64 126 1 1829542976 12731408 17083648
20:06:17 5731 8192000000 10751561408 11144609792 1814745360 18.135 100 79 158 1 1848826512 11837344 22243808
20:06:29 2675 8192000000 10769510208 11156430848 1833997392 18.292 100 88 174 2 1871070560 12265168 24808000
20:06:38 2604 8192000000 10769002864 11160477696 1838074592 18.325 100 82 161 2 1873486176 12146720 23264864
20:06:48 2633 8192000000 10786673728 11175321600 1843602752 18.370 100 82 164 0 1879320368 12905200 22812416
20:06:58 2012 8192000000 10786266144 11175493632 1845836528 18.388 100 88 176 1 1884295248 14111104 24347616
20:07:06 1940 8192000000 10792690992 11180908544 1848207744 18.408 100 87 174 0 1886963952 13416288 25339920
20:07:15 2481 8192000000 10801042064 11189415936 1858546480 18.491 100 88 176 2 1896700400 13416816 24737104
20:07:24 1935 8192000000 10807332624 11193892864 1864036016 18.536 100 92 183 2 1903022896 12387504 26599376
20:07:32 1200 8192000000 10814609200 11202420736 1871708800 18.598 100 95 191 0 1910869728 11948320 27212608
20:07:40 2245 8192000000 10813509488 11201798144 1874886512 18.624 100 95 190 3 1913566528 12667808 26012208
20:07:48 1288 8192000000 10815297216 11206180864 1876872336 18.640 100 92 188 1 1915461056 12074128 26514592
20:07:56 1708 8192000000 10828438688 11218911232 1885106432 18.706 100 95 190 1 1926343856 14395104 26842320
20:08:04 1523 8192000000 10828305120 11218944000 1882838432 18.688 100 94 189 1 1922807104 13883648 26085024
20:08:11 2190 8192000000 10812272704 11215511552 1879242832 18.659 100 66 132 1 1909846480 12287968 18315680
20:08:22 26724 8192000000 10797356080 11215405056 1875681152 18.630 100 43 85 0 1898040096 10019552 12339392
20:08:55 10173 8192000000 10817587824 11220004864 1878081872 18.650 100 41 82 0 1897001952 7044096 11875984
20:09:16 5128 8192000000 10787985360 11215208448 1879839296 18.664 100 33 66 0 1897486144 8652880 8993968
20:09:29 6194 8192000000 10821756128 11228925952 1888601264 18.735 100 36 71 1 1904717920 5973408 10143248
20:09:42 9493 8192000000 10807001184 11232301056 1887094128 18.722 100 27 52 1 1905003968 10983072 6926768
20:10:03 7302 8192000000 10799054592 11228635136 1887656016 18.727 100 18 36 1 1897765824 4713472 5396336
20:10:18 6757 8192000000 10805087248 11234746368 1894589984 18.783 100 20 40 2 1906271808 6306352 5375472
20:10:33 11460 8192000000 10804653360 11236990976 1893987696 18.778 100 15 30 0 1903920752 5368256 4564800
20:10:53 7892 8192000000 10810233792 11239714816 1897230624 18.804 100 15 30 2 1906961280 5474624 4256032
20:11:13 13246 8192000000 10805592528 11242856448 1901015856 18.834 100 26 52 3 1914236416 5784048 7436512
20:11:33 12830 8192000000 10810830032 11246555136 1900119008 18.827 100 14 27 0 1909985472 5870096 3996368
20:11:52 9629 8192000000 10816147504 11255480320 1907421520 18.886 100 24 48 1 1920455360 6473232 6560608
20:12:11 63237 8192000000 10829696720 11267379200 1912480064 18.927 100 30 60 1 1926028080 5458192 8089824
20:13:22 22282 8192000000 10834495024 11268591616 1915516944 18.951 100 34 68 3 1932645744 7408864 9719936
20:13:51 8653 8192000000 10836457728 11269840896 1918436800 18.974 100 29 58 2 1933574720 7209520 7928400
20:14:10 2775 8192000000 10853779776 11279179776 1922764992 19.009 100 39 77 1 1940767568 7183536 10819040
20:14:19 4876 8192000000 10847670000 11277000704 1921994240 19.003 100 36 72 1 1937881200 5007840 10879120
20:14:32 5994 8192000000 10848315200 11277484032 1924235440 19.021 100 34 67 0 1940641904 6262112 10144352
20:14:45 6552 8192000000 10844448656 11275857920 1924167008 19.020 100 27 54 0 1938302608 6461072 7674528
20:14:57 8432 8192000000 10844596880 11279114240 1924199664 19.020 100 31 62 3 1938344688 5131408 9013616
20:15:14 5534 8192000000 10838129696 11277893632 1921695008 19.000 100 16 32 0 1930925936 4828880 4402048
20:15:25 9608 8192000000 10840495072 11283341312 1925342784 19.030 100 20 40 3 1937113952 5747616 6023552
20:15:43 11432 8192000000 10834296960 11272437760 1904252976 18.860 99 10 20 1 1912876928 5585936 3038016
20:16:00 5771 8192000000 10844094144 11277119488 1926605520 19.040 100 29 58 2 1941251232 5307792 9337920
20:16:15 9999 8192000000 10832772544 11272949760 1920811200 18.993 100 22 44 1 1932406000 5176512 6418288
20:16:38 12871 8192000000 10822773968 11259965440 1866970560 18.560 97 17 34 1 1877670016 5425008 5274448
20:17:02 7432 8192000000 10804982560 11239051264 1867110448 18.561 98 24 48 2 1879805616 6228224 6466944
20:17:18 75108 8192000000 10742947280 11166044160 1709914608 17.268 90 24 48 3 1721792736 4567936 7310192
20:18:39 17958 8192000000 10760113360 11183230976 1743613808 17.549 93 18 35 2 1758083056 9585584 4883664
20:19:03 6594 8192000000 10755078992 11178004480 1810544816 18.100 98 36 70 0 1828860160 8379456 9935888
20:19:16 6257 8192000000 10730420816 11160981504 1785971584 17.899 97 32 64 1 1802546896 7749104 8826208
20:19:30 4784 8192000000 10719470000 11141644288 1772278928 17.786 97 36 72 1 1788417904 5176304 10962672
20:19:47 6360 8192000000 10681725728 11105198080 1758619312 17.673 97 20 40 2 1770795568 6371344 5804912
20:20:01 7015 8192000000 10697612224 11115900928 1770965920 17.775 99 25 50 0 1784099056 5372000 7761136
20:20:17 5154 8192000000 10688718352 11105185792 1734309424 17.471 97 34 68 2 1749892496 5249424 10333648
20:20:28 8242 8192000000 10662491920 11073626112 1672617376 16.955 94 19 37 1 1683145488 5342400 5185712
20:20:43 6930 8192000000 10691866432 11110895616 1759235248 17.678 99 33 66 3 1775372432 6801296 9335888
20:21:01 8971 8192000000 10687024624 11100925952 1715719040 17.316 96 20 40 1 1727199216 5830336 5649840
20:21:17 24032 8192000000 10737073152 11141365760 1766426368 17.738 98 28 56 0 1779482784 5075600 7980816
20:21:51 13138 8192000000 10725095200 11141566464 1771407536 17.779 98 23 46 1 1783409456 5116640 6885280
20:22:12 44046 8192000000 10748438400 11158056960 1817353376 18.156 100 37 73 0 1833688672 5649824 10685472
20:23:04 32263 8192000000 10726004256 11154407424 1792830912 17.955 98 31 61 2 1808342912 6745232 8766768
20:23:43 12323 8192000000 10742066576 11164344320 1826050192 18.227 100 22 44 2 1838224192 5452176 6721824
20:24:04 7623 8192000000 10750942016 11175481344 1839861072 18.340 100 38 76 0 1857356624 5551520 11944032
20:24:18 12349 8192000000 10754819344 11180244992 1838645888 18.330 100 15 30 0 1848598336 5820000 4132448
20:24:38 5857 8192000000 10753562352 11183304704 1843129408 18.366 100 18 34 1 1853750032 5620528 5000096
20:24:51 7240 8192000000 10768200496 11191402496 1846724944 18.396 100 26 52 1 1861006080 6992080 7289056
20:25:08 8326 8192000000 10764915344 11194650624 1857280080 18.481 100 32 63 2 1873101616 6729184 9092352
20:25:22 7742 8192000000 10771192032 11202150400 1855079696 18.463 100 21 42 1 1870940032 9993040 5867296
20:25:37 10048 8192000000 10776600064 11203411968 1860432288 18.507 100 32 62 4 1874785504 5836992 8516224
20:25:53 10787 8192000000 10772734832 11207614464 1860608704 18.508 100 12 23 1 1869494128 5225472 3659952
20:26:12 9663 8192000000 10780782256 11211657216 1865252704 18.546 100 22 44 1 1877435504 4966656 7216144
20:26:31 11213 8192000000 10784773088 11214688256 1869646128 18.581 100 25 47 2 1881319792 4788400 6885264
20:26:51 12179 8192000000 10780607904 11215286272 1869047376 18.577 100 11 22 0 1877142208 5136576 2958256
20:27:15 102507 8192000000 10830587168 11253682176 1897690864 18.808 100 49 96 2 1916806368 5428016 13687488
20:29:07 26398 8192000000 10853397920 11274719232 1917779264 18.969 100 50 100 1 1939682560 8241120 13662176
20:29:41 4593 8192000000 10870139712 11287654400 1928804832 19.057 100 54 109 1 1955722752 11794656 15123264
20:29:54 5955 8192000000 10865041088 11292622848 1935271728 19.109 100 54 106 1 1962499808 12087840 15140240
20:30:12 4114 8192000000 10893183360 11305725952 1941608416 19.160 100 68 134 1 1976752176 16195184 18948576
20:30:28 6827 8192000000 10895052784 11311312896 1947449792 19.206 100 67 132 2 1983358896 16743696 19165408
20:30:42 7504 8192000000 10886400224 11312263168 1951555744 19.239 100 67 134 1 1988245856 17048208 19641904
20:30:57 2414 8192000000 10896095968 11316281344 1951878544 19.241 100 64 128 1 1986322000 16184976 18258480
20:31:07 6196 8192000000 10892498544 11315630080 1937437168 19.126 99 63 125 2 1971483440 16222688 17823584
20:31:20 12254 8192000000 10883606672 11314335744 1951282144 19.237 100 52 103 1 1981449744 15049024 15118576
20:31:40 9079 8192000000 10886081328 11320565760 1955819184 19.273 100 49 94 2 1985442608 15181360 14442064
20:31:57 7824 8192000000 10915274480 11331596288 1963916416 19.337 100 60 121 0 1996900640 15317312 17666912
20:32:17 7832 8192000000 10912365136 11337687040 1969095920 19.378 100 71 142 2 2006120320 16071856 20952544
20:32:34 7087 8192000000 10922937632 11346141184 1974805792 19.424 100 60 118 3 2009439040 17490608 17142640
20:32:52 25159 8192000000 10931438240 11359444992 1977799584 19.447 100 65 130 1 2021549680 23870320 19879776
20:33:25 6953 8192000000 10927468736 11359965184 1983278560 19.491 100 58 115 0 2024976592 25036208 16661824
20:33:39 5939 8192000000 10934953648 11363479552 1987354144 19.523 100 74 147 0 2029612432 19813184 22445104
20:34:00 10619 8192000000 10927576176 11362152448 1987768112 19.526 100 52 104 1 2021696912 18508368 15420432
20:34:18 8784 8192000000 10935826912 11366629376 1990670080 19.549 100 61 120 5 2027173584 18561072 17942432
20:34:40 4641 8192000000 10949285344 11374170112 1995241824 19.585 100 55 110 1 2034388416 22307744 16838848
20:34:52 4855 8192000000 10943754176 11371945984 1996558256 19.596 100 67 129 3 2035764624 19762224 19444144
20:35:05 8215 8192000000 10943839120 11369279488 1991723040 19.557 100 61 120 1 2031037152 20999184 18314928
20:35:22 9108 8192000000 10925037648 11361337344 1972192480 19.403 99 47 94 0 2005265232 19317040 13755712
20:35:38 8431 8192000000 10938825888 11371343872 1989104416 19.537 100 54 105 1 2025854640 19753376 16996848
20:35:59 7775 8192000000 10940332480 11376664576 1995963808 19.591 100 54 107 2 2032061520 20041952 16055760
20:36:17 9914 8192000000 10938739728 11368038400 1991612576 19.557 100 65 128 4 2033444256 22613664 19218016
20:36:40 14106 8192000000 10951759856 11381907456 1999468016 19.619 100 74 144 2 2047581472 26255904 21857552
20:37:05 8639 8192000000 10954785856 11389386752 2002187520 19.640 100 55 110 3 2045863296 27319200 16356576
20:37:22 17248 8192000000 10937137600 11372552192 1980107248 19.466 99 57 112 2 2025480272 27736064 17636960
20:38:00 13973 8192000000 10958316848 11391172608 1999483504 19.619 100 54 107 3 2047275536 31200560 16591472
20:38:33 11068 8192000000 10952717536 11389509632 1992527696 19.564 100 45 89 1 2040307856 33741872 14038288
20:38:52 6666 8192000000 10959617024 11398811648 2006423472 19.673 100 60 120 1 2058454880 32464896 19566512
20:39:06 5827 8192000000 10971939120 11409027072 2009853936 19.700 100 55 107 0 2061275936 35393104 16028896
20:39:21 6727 8192000000 10960919856 11388141568 1985781776 19.510 99 72 138 2 2037178464 29436384 21960304
20:39:36 2777 8192000000 10984639296 11402641408 2011114912 19.710 100 87 174 1 2069111344 31067408 26929024
20:39:46 7128 8192000000 10973141184 11395694592 1992763920 19.566 99 74 146 2 2047111936 31750416 22597600
20:40:03 3014 8192000000 10979165056 11403759616 2007607984 19.683 100 76 153 2 2062947376 32676688 22662704
20:40:14 2961 8192000000 10967071840 11390402560 1999164064 19.616 100 80 160 3 2057219312 33336704 24718544
20:40:24 2802 8192000000 10982900336 11405127680 2007666416 19.683 100 83 165 1 2067055920 33970368 25419136
20:40:39 4845 8192000000 10976091952 11397595136 2001931696 19.638 100 71 142 2 2058083760 34318640 21833424
20:40:50 7558 8192000000 10974700848 11401203712 1989810576 19.542 99 70 140 3 2047330096 35425552 22093968
20:41:07 2461 8192000000 10983197632 11404271616 2006368496 19.673 100 73 146 0 2065155120 35725888 23060736
20:41:18 2781 8192000000 10974894160 11396636672 1995979568 19.591 100 71 141 0 2054946240 36384032 22582640
20:41:28 2806 8192000000 10972005632 11387789312 1977282960 19.443 99 73 145 1 2038076112 37429616 23363536
20:41:39 8942 8192000000 10961878176 11380969472 1965583728 19.350 99 77 154 1 2028998928 39319008 24096192
20:41:56 2447 8192000000 10966272256 11381342208 1988267744 19.530 100 91 179 0 2056322160 39643920 28410496
20:42:14 8598 8192000000 10968662160 11389886464 1991042592 19.552 100 69 138 0 2049236352 36947664 21246096
20:42:30 4887 8192000000 10983693376 11406626816 2000023392 19.623 100 66 132 0 2059720832 39025696 20671744
20:42:41 2788 8192000000 10978447904 11392581632 1993867632 19.574 100 81 159 2 2058307888 39108880 25331376
20:42:53 3567 8192000000 10950044000 11366064128 1967712016 19.367 100 83 166 1 2034593792 40477824 26403952
20:43:07 6567 8192000000 10943493568 11366146048 1964965408 19.345 100 64 126 1 2027511424 41889536 20656480
20:43:21 4523 8192000000 10947356192 11363483648 1962245472 19.324 100 79 157 1 2031021472 43578672 25197328
20:43:33 7583 8192000000 10927686528 11350020096 1944052096 19.179 99 71 143 1 2013411824 46315392 23044336
20:43:47 3696 8192000000 10942252880 11359629312 1944361392 19.182 99 68 136 1 2011767152 45874176 21531584
20:43:58 3055 8192000000 10960405040 11370971136 1963461088 19.334 100 89 175 1 2038173120 47835312 26876720
20:44:08 1497 8192000000 10947266160 11352084480 1944352224 19.181 99 87 172 0 2020031024 48253760 27425040
20:44:19 3785 8192000000 10958324736 11373297664 1967894544 19.369 100 81 163 1 2041197216 46782224 26520448
20:44:30 4883 8192000000 10954486432 11380088832 1972518768 19.405 100 68 136 2 2040291344 45928912 21843664
20:44:43 3919 8192000000 10968488432 11379175424 1959427520 19.301 99 87 175 1 2032173600 45720400 27025680
20:44:54 3589 8192000000 10970265488 11376484352 1969641488 19.383 100 87 172 1 2044484352 48039056 26803808
20:45:04 2237 8192000000 10972623040 11382104064 1973892784 19.416 100 90 178 1 2050886160 48601632 28391744
20:45:13 2228 8192000000 10976171760 11388448768 1983842240 19.495 100 91 182 4 2061223776 49995920 27385616
20:45:23 7350 8192000000 10965660752 11374579712 1957797584 19.289 99 80 161 0 2033015264 50108272 25109408
20:45:42 2372 8192000000 10954572688 11355738112 1936007200 19.115 99 90 180 1 2016340912 51308768 29024944
20:45:52 3552 8192000000 10934466256 11341684736 1941554528 19.159 100 82 161 1 2016405152 49061856 25788768
20:46:04 1741 8192000000 10943989504 11349336064 1946517376 19.199 100 84 166 0 2022528384 50142560 25868448
20:46:14 3704 8192000000 10926415584 11355402240 1945082768 19.187 100 63 126 0 2015634368 50961664 19589936
20:46:30 5223 8192000000 10897385056 11315892224 1908472368 18.894 98 57 113 2 1971766160 44671696 18622096
20:46:42 2846 8192000000 10924444608 11339964416 1941206608 19.156 100 82 164 1 2010946096 43983632 25755856
20:46:53 8566 8192000000 10913689296 11337867264 1928994144 19.059 100 57 115 1 1994936528 46962544 18979840
20:47:12 4423 8192000000 10928500816 11350564864 1945569872 19.191 100 65 130 2 2012454352 45937712 20946768
20:47:23 9672 8192000000 10902179408 11332251648 1922220816 19.005 99 47 93 0 1980295264 42216304 15858144
20:47:40 5232 8192000000 10913891184 11341774848 1939661872 19.144 100 50 100 0 1995253104 39393568 16197664
20:47:58 11019 8192000000 10913212544 11348996096 1947299760 19.205 100 48 96 0 2004923392 40808624 16815008
20:48:16 10247 8192000000 10923544480 11355348992 1952042464 19.243 100 49 95 2 2011097968 42746688 16308816
20:48:34 10080 8192000000 10910724720 11353325568 1945383280 19.190 100 39 78 1 2000824096 42295472 13145344
20:48:59 14532 8192000000 10931474288 11362082816 1952483296 19.246 100 55 108 1 2015508224 45011312 18013616
20:49:35 14294 8192000000 10922681856 11369877504 1951168912 19.236 100 42 85 3 2010358336 44752144 14437280
20:49:59 23584 8192000000 10923317968 11365318656 1936585296 19.119 99 32 64 0 1991432352 42942192 11904864
20:50:29 19932 8192000000 10926558320 11368087552 1953988336 19.258 100 28 56 2 2008840400 44562480 10289584
20:50:57 21076 8192000000 10914027344 11369623552 1951154496 19.236 100 32 64 0 2006236160 43508256 11573408
20:51:24 10639 8192000000 10900441360 11363794944 1926602080 19.040 99 24 48 1 1975884608 40888768 8393760
20:51:43 11371 8192000000 10901245280 11343781888 1914928752 18.946 99 36 72 1 1971203984 44741904 11533328
20:52:02 22898 8192000000 10891224656 11348676608 1930613856 19.072 100 24 48 1 1981910832 42838752 8458224
20:52:56 22235 8192000000 10897891856 11342716928 1935945680 19.114 100 19 38 1 1984633648 41506784 7181184
20:53:27 33219 8192000000 10875132432 11336224768 1914921296 18.946 99 24 49 4 1950032816 27323760 7787760
20:54:07 37086 8192000000 10845768544 11315372032 1884325152 18.700 98 14 28 0 1915074240 26641568 4107520
20:55:29 103010 8192000000 10845615552 11281858560 1783149664 17.875 93 19 37 1 1802563504 14945168 4468672
20:57:18 28944 8192000000 10866334304 11300753408 1909297664 18.901 99 33 66 2 1933555696 14561936 9696096
20:58:09 54828 8192000000 10892848304 11342516224 1941215488 19.156 100 33 66 5 1972371936 21756464 9399984
20:59:10 66460 8192000000 10892080880 11344347136 1943950592 19.178 100 18 36 3 1968983872 19763968 5269312
21:00:34 109121 8192000000 10901080192 11376205824 1956410944 19.278 100 7 14 1 1979757136 21862128 1484064
21:03:01 68737 8192000000 10899030320 11347595264 1934554032 19.103 98 28 56 1 1948619120 6950832 7114256
21:04:16 65220 8192000000 10905949856 11355709440 1954816800 19.265 99 40 80 0 1975773216 9097872 11858544
21:05:39 21171 8192000000 10889991232 11351465984 1946848976 19.201 99 22 44 1 1963328784 10030016 6449792
21:06:07 3938 8192000000 10897887408 11348332544 1957637472 19.287 100 27 53 3 1975326528 9575888 8113168
21:06:17 33232 8192000000 10893070480 11357839360 1961365216 19.317 100 19 38 1 1976497376 9932928 5199232
21:07:04 45283 8192000000 10900077232 11358851072 1952201168 19.244 99 28 56 0 1975095104 14525296 8368640
21:08:03 53484 8192000000 10909604176 11370622976 1955670144 19.272 99 28 56 1 1980652528 16337344 8645040
21:09:02 34622 8192000000 10903362672 11364835328 1971440352 19.397 100 19 38 0 1985376144 8182128 5753664
21:09:46 103678 8192000000 10915102640 11382095872 1989235744 19.538 100 17 34 3 2004879952 10261920 5382288
21:11:36 31679 8192000000 10915881600 11381194752 1973237712 19.411 99 17 34 0 1989005280 10370976 5396592
21:12:35 47271 8192000000 10914733632 11387281408 1983559120 19.493 100 14 28 1 2000038128 12310192 4168816
21:14:08 34337 8192000000 10893016912 11371446272 1966820864 19.360 99 11 22 0 1982953648 11983152 4149632
21:15:26 48849 8192000000 10913109664 11379228672 1974402112 19.420 100 30 60 0 1996683904 13548160 8733632
21:16:22 26875 8192000000 10902018960 11374510080 1979414848 19.460 100 14 28 1 1991161664 7850496 3896320
21:17:39 62025 8192000000 10902302000 11380568064 1983632192 19.493 100 25 50 0 1998640944 8097968 6910784
21:20:01 57275 8192000000 10885215872 11369738240 1956358272 19.277 99 12 24 0 1967749664 7645280 3746112
21:21:06 46561 8192000000 10900894880 11370213376 1937852928 19.130 98 15 30 0 1951362912 9209696 4300288
21:22:00 25168 8192000000 10870671536 11333586944 1894996384 18.786 96 18 36 1 1910147776 10065408 5085984
21:22:38 18860 8192000000 10886462128 11352031232 1940861088 19.154 99 39 77 1 1963466656 12103088 10502480
21:23:07 43508 8192000000 10898733840 11368996864 1938412256 19.134 98 28 57 4 1961831680 15066864 8352560
21:23:57 77360 8192000000 10881644096 11352813568 1873590144 18.613 95 15 30 0 1894500784 16500640 4410000
21:25:21 42432 8192000000 10864281152 11340230656 1869745664 18.582 96 11 22 0 1892529184 18991920 3791600
21:26:17 33890 8192000000 10898502080 11357265920 1954563024 19.263 100 33 66 1 1974071104 10486720 9021360
21:27:00 52234 8192000000 10885440176 11361808384 1942904816 19.170 99 25 50 1 1966082416 16258224 6919376
21:28:01 44864 8192000000 10886819424 11363934208 1941302800 19.157 99 19 38 0 1962848640 16132432 5413408
21:28:53 59187 8192000000 10905218656 11366338560 1950656000 19.232 99 23 46 1 1974774240 17714880 6403360
21:30:03 66957 8192000000 10856757648 11327000576 1900565648 18.831 96 10 20 1 1919326144 15835808 2924688
21:31:17 85055 8192000000 10881487024 11352821760 1842750176 18.363 94 12 24 0 1860322144 14282928 3289040
21:33:38 40779 8192000000 10875248240 11320197120 1886521040 18.718 97 28 57 0 1905558544 9520160 9517344
21:34:25 101035 8192000000 10853474704 11317407744 1895883056 18.793 97 51 100 2 1925870592 15219536 14768000
21:36:34 72753 8192000000 10856188240 11329040384 1852186416 18.440 96 19 38 1 1871156832 13660016 5310400
21:37:57 43510 8192000000 10851470432 11317927936 1876609184 18.638 97 33 66 2 1895729184 9152720 9967280
21:39:02 55540 8192000000 10848204432 11319107584 1907193664 18.884 99 16 32 1 1925868512 13696144 4978704
21:40:09 67363 8192000000 10838649312 11308044288 1844839120 18.380 96 18 36 1 1865159312 14389456 5930736
21:41:22 77714 8192000000 10840148720 11319476224 1887323680 18.724 98 17 34 3 1915683424 22507920 5851824
21:42:47 56251 8192000000 10835871840 11308482560 1862082416 18.520 97 10 20 1 1880129904 14869536 3177952
21:44:09 41538 8192000000 10842593856 11315892224 1897655984 18.807 99 30 58 2 1920548096 14285920 8606192
21:45:02 89796 8192000000 10857408208 11344564224 1895979360 18.794 98 22 44 1 1919990160 18134752 5876048
21:46:40 40307 8192000000 10871861888 11315113984 1869071888 18.577 97 27 54 2 1896705664 18925584 8708192
21:47:26 37075 8192000000 10864589808 11333365760 1910694896 18.912 99 32 64 0 1934501072 14448352 9357824
21:48:10 45038 8192000000 10855293904 11322912768 1884143776 18.699 98 23 45 0 1902400656 11892704 6364176
21:49:01 81663 8192000000 10867801584 11333656576 1892007584 18.762 98 22 43 2 1910211680 12145728 6058368
21:50:29 56452 8192000000 10893401968 11346354176 1942267216 19.165 100 29 58 0 1960786992 10859424 7660352
21:51:32 35644 8192000000 10896118384 11350417408 1933032064 19.091 99 32 64 0 1952935696 11065104 8838528
21:52:15 64409 8192000000 10870112096 11341987840 1915546048 18.951 98 15 30 3 1932568192 13037360 3984784
21:53:29 48355 8192000000 10878292992 11363307520 1944554256 19.183 100 13 26 0 1960501776 12257632 3689888
21:54:26 66546 8192000000 10889262688 11351842816 1940141328 19.148 99 32 64 2 1960608528 11210352 9256848
21:56:07 75229 8192000000 10879473456 11356778496 1941417344 19.158 99 37 74 1 1965729968 13898240 10414384
21:57:35 73405 8192000000 10892538000 11363598336 1951738560 19.240 99 32 64 2 1974075776 13120768 9216448
21:59:01 90128 8192000000 10892299072 11388383232 1968797280 19.376 100 8 16 1 1982968224 12368752 1802192
22:00:38 25397 8192000000 10890883744 11380518912 1953599568 19.255 99 9 18 0 1969856288 14546016 1710704
22:01:12 33008 8192000000 10903802656 11376181248 1970664000 19.391 100 7 14 1 1988428672 15987040 1777632
22:01:52 55394 8192000000 10891025712 11381731328 1954521568 19.262 99 11 22 0 1968695120 11423168 2750384
22:03:29 101988 8192000000 10893935760 11386048512 1936623536 19.120 98 19 38 0 1954442384 12639888 5178960
22:05:22 54730 8192000000 10916593856 11393191936 1971013200 19.393 99 30 60 0 1991235344 11996960 8225184
22:06:23 84212 8192000000 10922244112 11401478144 1971205040 19.395 99 17 32 0 1991422864 15485312 4732512
22:08:00 39128 8192000000 10903471520 11389931520 1969045408 19.378 100 18 36 0 1991026592 16690000 5291184
22:08:59 99782 8192000000 10903651072 11385294848 1904162368 18.860 96 4 8 0 1915818128 10710272 945488
22:10:51 76834 8192000000 10920726640 11399811072 1962092816 19.323 99 24 49 0 1982856864 13820096 6943952
22:12:14 114861 8192000000 10888234064 11355824128 1808756288 18.086 91 21 42 1 1829381504 14793520 5831696
22:14:16 63208 8192000000 10911976736 11373355008 1927608448 19.048 98 27 54 1 1947417952 12861392 6948112
22:15:25 90639 8192000000 10894431936 11386904576 1927790656 19.049 98 25 50 1 1952804912 17869856 7144400
22:17:02 108080 8192000000 10898205968 11366301696 1945231056 19.188 99 13 25 1 1966011408 17529216 3251136
22:18:56 91751 8192000000 10902720080 11372109824 1914437664 18.942 97 20 40 1 1929129600 9385008 5306928
22:20:34 22649 8192000000 10901487712 11364843520 1943507984 19.175 99 29 58 0 1966210400 14598368 8104048
22:21:03 14438 8192000000 10881226128 11356512256 1940652784 19.152 99 28 56 0 1965156448 16625472 7878192
22:21:42 56927 8192000000 10867513296 11361120256 1897457056 18.806 97 11 23 0 1913668016 13379552 2831408
22:22:45 33837 8192000000 10859820080 11340062720 1923739248 19.017 99 10 20 0 1945378816 18731200 2908368
22:23:25 51095 8192000000 10875363344 11352326144 1931053584 19.075 99 15 30 1 1942941760 6909792 4978384
22:24:23 57939 8192000000 10883294208 11360743424 1932172368 19.084 99 13 26 1 1947342512 11726400 3443744
22:26:06 68930 8192000000 10876685744 11353706496 1937984256 19.131 99 20 40 0 1955469728 11441040 6044432

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:31, from 09-03-2021 22:29:46 to 09-03-2021 22:30:17.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 125 v_add_invoice_to_stock 335544517
except 9 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 09-03-2021 22:30:18 to 09-03-2021 22:30:20.

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          239267
MON$OLDEST_ACTIVE               239862
MON$OLDEST_SNAPSHOT             239862
MON$NEXT_TRANSACTION            239862
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                       2049120
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.33423 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33423 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33423 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33423 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 ---
:243: 
:244: mscs-test-161.budzdorov.ru    Tue Mar  9 22:27:41 2021
:245:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:246: 
:247: 
:248: mscs-test-161.budzdorov.ru    Tue Mar  9 22:27:41 2021
:249:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:250: 
--- end of diff output ---

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

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