Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 13.01.2021 19: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 17265676 kB
MemAvailable 31384396 kB
Buffers 0 kB
Cached 14458628 kB
SwapCached 4864 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-01-13 19:27:12
DTS_END                         2021-01-13 19:27:12.4240
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/40496
TRN_ID                          244171
ATT_ID                          627
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: 9217.27 20194 1106072
customer order: creation 175.84 337 21101
customer order: refuse 15.33 354 1839
order to supplier: creation 46.51 1335 5581
order to supplier: removal 3.35 104289 402
invoice (draft): creation 46.53 3546 5583
invoice (draft): removal 51.98 758 6237
invoice accept: apply 42.53 18561 5104
invoice accept: cancel 47.13 845 5656
customer reserve: creation 3860.58 187 463269
customer reserve: removal 4631.98 59 555837
realization accept: apply 86.48 173 10377
realization accept: cancel 76.21 112 9145
payment from customer: creation 61.40 117 7368
payment from customer: removal 5.94 80 713
payment to supplier: creation 49.80 124 5976
payment to supplier: removal 3.62 73 434
service: total inventory turnovers 4.56 1143 547
service: total monetary turnovers 6.61 33 793
service: aggregate perf. data 0.88 21326 106
service: refresh index statistics 0.03 250421 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 13-01-2021 19:29:19 to 13-01-2021 19:29:22.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 10143
TEST_TIME 2 6255
TEST_TIME 3 4961
TEST_TIME 4 6703
TEST_TIME 5 6755
TEST_TIME 6 6644
TEST_TIME 7 6269
TEST_TIME 8 6327
TEST_TIME 9 6297
TEST_TIME 10 6295
TEST_TIME 11 6169
TEST_TIME 12 6377
TEST_TIME 13 6409
TEST_TIME 14 6415
TEST_TIME 15 6609
TEST_TIME 16 6702
TEST_TIME 17 6854
TEST_TIME 18 6912
TEST_TIME 19 6813
TEST_TIME 20 7063
TEST_TIME 21 7135
TEST_TIME 22 8049
TEST_TIME 23 8117
TEST_TIME 24 8445
TEST_TIME 25 8707
TEST_TIME 26 9161
TEST_TIME 27 8911
TEST_TIME 28 9113
TEST_TIME 29 9594
TEST_TIME 30 9906
TEST_TIME 31 10433
TEST_TIME 32 10383
TEST_TIME 33 10243
TEST_TIME 34 10127
TEST_TIME 35 10049
TEST_TIME 36 10059
TEST_TIME 37 9971
TEST_TIME 38 9897
TEST_TIME 39 9950
TEST_TIME 40 9932
TEST_TIME 41 9893
TEST_TIME 42 9886
TEST_TIME 43 9774
TEST_TIME 44 9794
TEST_TIME 45 9766
TEST_TIME 46 9689
TEST_TIME 47 9744
TEST_TIME 48 9671
TEST_TIME 49 9591
TEST_TIME 50 9528
TEST_TIME 51 9426
TEST_TIME 52 9404
TEST_TIME 53 9296
TEST_TIME 54 9279
TEST_TIME 55 9353
TEST_TIME 56 9320
TEST_TIME 57 9224
TEST_TIME 58 9300
TEST_TIME 59 9520
TEST_TIME 60 9645
TEST_TIME 61 9597
TEST_TIME 62 9773
TEST_TIME 63 9748
TEST_TIME 64 9740
TEST_TIME 65 9695
TEST_TIME 66 9803
TEST_TIME 67 9802
TEST_TIME 68 9693
TEST_TIME 69 9639
TEST_TIME 70 9626
TEST_TIME 71 9648
TEST_TIME 72 9564
TEST_TIME 73 9492
TEST_TIME 74 9413
TEST_TIME 75 9425
TEST_TIME 76 9365
TEST_TIME 77 9328
TEST_TIME 78 9326
TEST_TIME 79 9400
TEST_TIME 80 9392
TEST_TIME 81 9399
TEST_TIME 82 9371
TEST_TIME 83 9438
TEST_TIME 84 9438
TEST_TIME 85 9494
TEST_TIME 86 9530
TEST_TIME 87 9504
TEST_TIME 88 9512
TEST_TIME 89 9643
TEST_TIME 90 9544
TEST_TIME 91 9485
TEST_TIME 92 9479
TEST_TIME 93 9473
TEST_TIME 94 9421
TEST_TIME 95 9363
TEST_TIME 96 9363
TEST_TIME 97 9369
TEST_TIME 98 9406
TEST_TIME 99 9384
TEST_TIME 100 9347
TEST_TIME 101 9352
TEST_TIME 102 9476
TEST_TIME 103 9457
TEST_TIME 104 9466
TEST_TIME 105 9466
TEST_TIME 106 9445
TEST_TIME 107 9495
TEST_TIME 108 9484
TEST_TIME 109 9512
TEST_TIME 110 9523
TEST_TIME 111 9451
TEST_TIME 112 9439
TEST_TIME 113 9399
TEST_TIME 114 9367
TEST_TIME 115 9372
TEST_TIME 116 9347
TEST_TIME 117 9330
TEST_TIME 118 9283
TEST_TIME 119 9298
TEST_TIME 120 9222

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 13-01-2021 19:29:23 to 13-01-2021 19:29:26.

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 1534859 1534859 0 0.00 0 15395 7 0 0
doc_list_biud 1534858 1534858 0 0.00 0 70586 27 0 0
sp_add_invoice_to_stock 5283 5104 179 3.38 34 198276 18562 0 179
sp_cancel_adding_invoice 5656 5656 0 0.00 6 58770 845 0 0
sp_cancel_client_order 1839 1839 0 0.00 4 12326 354 0 0
sp_cancel_customer_reserve 555837 555837 0 0.00 1 70588 60 0 0
sp_cancel_pay_from_customer 713 713 0 0.00 3 5636 81 0 0
sp_cancel_pay_to_supplier 434 434 0 0.00 2 3401 73 0 0
sp_cancel_supplier_invoice 6246 6237 9 0.14 2 16821 759 0 9
sp_cancel_supplier_order 402 402 0 0.00 7 1103945 104290 0 0
sp_cancel_write_off 9145 9145 0 0.00 1 9218 112 0 0
sp_client_order 21101 21101 0 0.00 3 26702 338 0 0
sp_customer_reserve 463269 463269 0 0.00 0 108637 188 0 0
sp_fill_shopping_cart 32251 32251 0 0.00 1 24733 41 0 0
sp_fill_shopping_cart_clo_res 463257 463257 0 0.00 0 15847 13 0 0
sp_get_clo_for_invoice 5092 5092 0 0.00 0 25133 290 0 0
sp_kill_cost_storno 15948 15948 0 0.00 0 6384 57 0 0
sp_kill_qstorno_ret_qs2qd 1127458 1127458 0 0.00 0 70580 32 0 0
sp_kill_qty_storno 594585 594585 0 0.00 0 70586 69 0 0
sp_lock_selected_doc 21390 21390 0 0.00 0 6739 4 0 0
sp_make_cost_storno 28813 28813 0 0.00 0 9722 49 0 0
sp_multiply_rows_for_pdistr 28813 28813 0 0.00 0 7993 29 0 0
sp_multiply_rows_for_qdistr 21101 21101 0 0.00 0 10893 146 0 0
sp_pay_from_customer 7368 7368 0 0.00 4 26905 117 0 0
sp_pay_to_supplier 5976 5976 0 0.00 5 8828 125 0 0
sp_payment_common 13344 13344 0 0.00 1 26888 32 0 0
sp_qd_handle_on_cancel_clo 1839 1839 0 0.00 0 12318 324 0 0
sp_qd_handle_on_invoice_upd_sts 10748 10748 0 0.00 0 19793 336 0 0
sp_qd_handle_on_reserve_upd_sts 10377 10377 0 0.00 0 19298 60 0 0
sp_reserve_write_off 10377 10377 0 0.00 6 19337 174 0 0
sp_supplier_invoice 5583 5583 0 0.00 6 79667 3547 0 0
sp_supplier_order 5581 5581 0 0.00 5 50588 1335 0 0
srv_aggregate_perf_data 106 106 0 0.00 2675 327683 21326 0 0
srv_fill_mon_cache_memory 169 169 0 0.00 1404 140070 32357 0 0
srv_find_qd_qs_mism 1057489 1057489 0 0.00 0 15367 6 0 0
srv_make_invnt_saldo 547 547 0 0.00 31 62938 1143 0 0
srv_make_money_saldo 793 793 0 0.00 0 5019 34 0 0
srv_recalc_idx_stat 4 4 0 0.00 125446 465783 250421 0 0
t$perf-abend:sp_add_invoice_to_stock 179 179 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 5104 5104 0 0.00 0 14246 182 0 0
t$perf-norm:sp_cancel_adding_invoice 399 399 0 0.00 0 7431 126 0 0
t$perf-norm:sp_cancel_client_order 1839 1839 0 0.00 0 2635 13 0 0
t$perf-norm:sp_cancel_customer_reserve 699 699 0 0.00 0 4483 16 0 0
t$perf-norm:sp_cancel_pay_from_customer 713 713 0 0.00 0 1838 7 0 0
t$perf-norm:sp_cancel_pay_to_supplier 434 434 0 0.00 0 179 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 390 390 0 0.00 0 3230 28 0 0
t$perf-norm:sp_cancel_supplier_order 402 402 0 0.00 0 35714 1756 0 0
t$perf-norm:sp_cancel_write_off 1046 1046 0 0.00 0 3424 9 0 0
t$perf-norm:sp_client_order 21101 21101 0 0.00 0 10749 22 0 0
t$perf-norm:sp_customer_reserve 1058 1058 0 0.00 0 1152 4 0 0
t$perf-norm:sp_pay_from_customer 7368 7368 0 0.00 0 7963 15 0 0
t$perf-norm:sp_pay_to_supplier 5976 5976 0 0.00 0 6412 12 0 0
t$perf-norm:sp_reserve_write_off 10377 10377 0 0.00 0 9062 13 0 0
t$perf-norm:sp_supplier_invoice 5583 5583 0 0.00 0 6252 20 0 0
t$perf-norm:sp_supplier_order 5581 5581 0 0.00 0 4774 17 0 0
t$perf-norm:srv_aggregate_perf_data 106 106 0 0.00 0 264 7 0 0
t$perf-norm:srv_fill_mon_cache_memory 169 169 0 0.00 0 691 6 0 0
t$perf-norm:srv_make_invnt_saldo 547 547 0 0.00 0 3031 28 0 0
t$perf-norm:srv_make_money_saldo 793 793 0 0.00 0 1285 21 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 3 2 0 0
v_add_invoice_to_stock 10542 10184 358 3.39 0 3437 18 0 358
v_all_customers 37978 37978 0 0.00 0 15 1 0 0
v_all_suppliers 30756 30756 0 0.00 0 16 1 0 0
v_all_wares 42198 42198 0 0.00 0 74 1 0 0
v_cancel_adding_invoice 798 798 0 0.00 0 382 7 0 0
v_cancel_client_order 3678 3678 0 0.00 0 4386 6 0 0
v_cancel_customer_prepayment 1426 1426 0 0.00 0 4163 6 0 0
v_cancel_customer_reserve 1398 1398 0 0.00 0 7399 9 0 0
v_cancel_payment_to_supplier 868 868 0 0.00 0 3211 10 0 0
v_cancel_supplier_invoice 798 780 18 2.25 0 1196 16 0 18
v_cancel_supplier_order 804 804 0 0.00 0 213 3 0 0
v_cancel_write_off 2092 2092 0 0.00 0 6668 17 0 0
v_max_id_clo_ord 5578 5578 0 0.00 0 1755 2 0 0
v_max_id_clo_res 1058 1058 0 0.00 0 4114 12 0 0
v_max_id_ord_sup 5573 5573 0 0.00 0 1197 2 0 0
v_max_non_paid_invoice 1749 1749 0 0.00 0 4543 6 0 0
v_max_non_paid_realizn 4183 4183 0 0.00 0 4935 11 0 0
v_min_id_clo_ord 5578 5578 0 0.00 0 20267 12 0 0
v_min_id_clo_res 1058 1058 0 0.00 0 5638 8 0 0
v_min_id_ord_sup 5573 5573 0 0.00 0 5498 8 0 0
v_min_non_paid_invoice 5976 5976 0 0.00 0 6557 15 0 0
v_min_non_paid_realizn 7368 7368 0 0.00 0 12050 16 0 0
v_our_firm 10590 10590 0 0.00 0 15 1 0 0
v_reserve_write_off 20752 20752 0 0.00 0 4742 6 0 0
x_lock_depdocs_on_canc_invoice 11503 11503 0 0.00 0 15215 116 0 0
x_lock_depdocs_on_canc_sup_ord 402 402 0 0.00 0 5209 365 0 0
x_make_qstorno_1000_1200 5581 5581 0 0.00 2 50569 1243 0 0
x_make_qstorno_1200_2000 5583 5583 0 0.00 3 79172 3400 0 0
x_make_qstorno_2100_3300 463269 463269 0 0.00 0 108635 172 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 13-01-2021 19:29:27 to 13-01-2021 19:29:31.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
16:57:16 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
16:57:22 16873 8192000000 10229859904 10536116224 904790288 9.946 72 52 107 1 924383632 2573792 17019552
16:57:47 34778 8192000000 10347586928 10662674432 1388538080 14.493 100 85 170 0 1420689920 4685600 27466240
16:58:35 15985 8192000000 10373588688 10696482816 1432667120 14.885 100 84 168 0 1466954944 6609360 27678464
16:59:00 21794 8192000000 10395696928 10724524032 1452719232 15.062 100 90 180 0 1488721392 7115888 28886272
16:59:31 12511 8192000000 10414087680 10749595648 1481529136 15.315 100 83 166 0 1515175664 7850768 25795760
16:59:56 30723 8192000000 10444904128 10778988544 1502105200 15.495 100 91 182 0 1539869760 8787952 28976608
17:00:36 13322 8192000000 10453626080 10787254272 1512606160 15.586 100 91 182 0 1551387504 9589312 29192032
17:01:00 17510 8192000000 10463639232 10805211136 1524705712 15.691 100 80 160 0 1559356000 9483904 25166384
17:01:26 22504 8192000000 10491867808 10839781376 1546033120 15.876 100 77 154 0 1579221664 9417936 23770608
17:01:58 6720 8192000000 10518510528 10866970624 1578577392 16.156 100 85 170 1 1614310672 9658864 26074416
17:02:11 16975 8192000000 10538429360 10894835712 1597821808 16.321 100 81 162 1 1632849232 10232464 24794960
17:02:41 17293 8192000000 10576989744 10930249728 1630524640 16.599 100 88 176 1 1668275008 11094464 26655904
17:03:12 12639 8192000000 10583671632 10948595712 1642243024 16.699 100 77 154 0 1676351312 11576384 22531904
17:03:32 16038 8192000000 10628065552 10989543424 1675556544 16.980 100 81 162 1 1711558016 12199504 23801968
17:03:57 7338 8192000000 10634137664 10998210560 1690363888 17.104 100 88 176 1 1728929168 12941600 25623680
17:04:12 12857 8192000000 10643362656 11016384512 1700662800 17.191 100 78 156 1 1735455632 12228272 22564560
17:04:33 5432 8192000000 10654331856 11026059264 1721185392 17.362 100 81 161 0 1756852896 12432848 23234656
17:04:48 8651 8192000000 10675685392 11053264896 1734366848 17.472 100 81 162 1 1770787248 12965264 23455136
17:05:04 6009 8192000000 10687435136 11067019264 1757815632 17.666 100 81 161 3 1792788384 12299920 22672832
17:05:18 4513 8192000000 10706450848 11081322496 1768781328 17.757 100 78 156 0 1802378992 12146416 21451248
17:05:31 6477 8192000000 10719727392 11099758592 1778787808 17.839 100 81 161 0 1814554048 13040864 22725376
17:05:44 3458 8192000000 10720402672 11100696576 1784150080 17.884 100 79 157 0 1819710576 13600880 21959616
17:05:55 3147 8192000000 10729249808 11110125568 1790602576 17.937 100 87 174 4 1828596016 13689296 24304144
17:06:05 4348 8192000000 10739529520 11118276608 1798940528 18.005 100 92 184 1 1839784048 15241872 25601648
17:06:16 2915 8192000000 10748168896 11127746560 1801379136 18.025 100 84 168 1 1839291760 14016976 23895648
17:06:25 4582 8192000000 10746703520 11130720256 1807499568 18.075 100 85 170 0 1845091136 14149712 23441856
17:06:37 3067 8192000000 10757295184 11139850240 1811827712 18.111 100 82 164 0 1848681440 13734208 23119520
17:06:46 1966 8192000000 10762839472 11142918144 1819669600 18.175 100 88 178 1 1857892480 14112544 24110336
17:06:55 6966 8192000000 10745382624 11141644288 1815926528 18.144 100 70 138 3 1848004992 12623488 19454976
17:07:09 2044 8192000000 10775825424 11161620480 1825211344 18.220 100 90 180 2 1863471008 12624032 25635632
17:07:18 2174 8192000000 10779916304 11165351936 1838921296 18.332 100 88 175 3 1876269904 13071472 24277136
17:07:26 2473 8192000000 10788999264 11175157760 1845698608 18.387 100 92 184 0 1885880096 14542000 25639488
17:07:35 1532 8192000000 10798841728 11184095232 1853554096 18.451 100 89 176 0 1892090672 14332688 24203888
17:07:43 1959 8192000000 10805099536 11190091776 1856546096 18.475 100 92 182 1 1897279200 15620784 25112320
17:07:51 1925 8192000000 10805064032 11193274368 1858056592 18.488 100 92 182 1 1899296448 15841152 25398704
17:07:59 1800 8192000000 10806247168 11193311232 1863913200 18.535 100 88 176 0 1902831760 14653200 24265360
17:08:08 1787 8192000000 10808046416 11196833792 1866171600 18.553 100 98 198 0 1908152096 13965744 28014752
17:08:16 1277 8192000000 10814204784 11201630208 1865739008 18.550 100 93 187 0 1904369408 12779216 25851184
17:08:23 1600 8192000000 10817454224 11205275648 1870568112 18.589 100 93 188 1 1910124400 12354704 27201584
17:08:31 1754 8192000000 10824492288 11210575872 1873161184 18.610 100 92 185 1 1912964352 13604720 26198448
17:08:39 2065 8192000000 10824060752 11212435456 1876194752 18.634 100 97 194 1 1917732032 13970960 27566320
17:08:47 1622 8192000000 10822904992 11210629120 1876877488 18.640 100 95 193 0 1916504400 11473040 28153872
17:08:55 1374 8192000000 10817052240 11208757248 1877692528 18.646 100 95 191 0 1917486768 12776160 27018080
17:09:03 1090 8192000000 10812902752 11214618624 1878480992 18.653 100 75 150 0 1912228464 12517680 21229792
17:09:14 32241 8192000000 10815835472 11218395136 1875366656 18.628 100 53 106 2 1897609024 7085536 15156832
17:09:52 6470 8192000000 10809017376 11213254656 1876594768 18.638 100 48 96 0 1898730336 8741040 13394528
17:10:06 2620 8192000000 10800622160 11218759680 1878310432 18.651 100 44 88 0 1900418736 9862256 12246048
17:10:17 10869 8192000000 10780641632 11213746176 1878721040 18.655 100 25 48 2 1891887552 6138512 7028000
17:10:37 6239 8192000000 10799289968 11229458432 1883683664 18.695 100 28 56 1 1902143456 10838048 7621744
17:10:53 8283 8192000000 10796540656 11224252416 1883947264 18.697 100 22 44 0 1896421808 6270832 6203712
17:11:07 11685 8192000000 10790248736 11221573632 1882380592 18.684 100 12 24 0 1890691968 5263232 3048144
17:11:26 10951 8192000000 10797321552 11231367168 1887095504 18.722 100 15 30 0 1896845024 5596976 4152544
17:11:44 13314 8192000000 10806579296 11236499456 1890231104 18.748 100 10 20 3 1898534320 5037520 3265696
17:12:04 16181 8192000000 10795534256 11233976320 1890840000 18.753 100 13 26 1 1900606144 5939632 3826512
17:12:34 11591 8192000000 10812351760 11239809024 1896061824 18.795 100 18 37 1 1906895520 5528448 5305248
17:12:56 15901 8192000000 10807804240 11243360256 1898211856 18.812 100 12 24 0 1907147632 5789056 3146720
17:13:18 27898 8192000000 10807065232 11250380800 1907080112 18.883 100 24 47 1 1919109648 5083552 6945984
17:13:54 49065 8192000000 10836349392 11260268544 1909804000 18.905 100 45 88 3 1928906144 5770080 13332064
17:14:49 15855 8192000000 10822545552 11258531840 1909125648 18.900 100 28 56 1 1922998096 5670400 8202048
17:15:13 5153 8192000000 10822069664 11259531264 1909234880 18.901 100 19 37 0 1921353248 6479728 5638640
17:15:27 6523 8192000000 10826701648 11267788800 1913959072 18.938 100 31 62 0 1934325600 11022544 9343984
17:15:39 7102 8192000000 10824797088 11262038016 1912499808 18.927 100 23 46 0 1924894352 5278480 7116064
17:15:53 6567 8192000000 10824859408 11260653568 1911547760 18.919 100 21 42 1 1923282080 5586640 6147680
17:16:08 7014 8192000000 10823532288 11264782336 1912409296 18.926 100 19 38 2 1923668912 5850816 5408800
17:16:21 7494 8192000000 10818953296 11253194752 1892437168 18.765 99 25 50 1 1905598736 5723184 7438384
17:16:35 5907 8192000000 10811461440 11238924288 1880719840 18.671 99 25 50 1 1894357872 6380496 7257536
17:16:47 7446 8192000000 10803851984 11237363712 1889849856 18.745 99 27 54 1 1904303056 7112976 7340224
17:17:01 11631 8192000000 10801348688 11238703104 1861387952 18.515 98 14 28 1 1875299680 9859600 4052128
17:17:19 8933 8192000000 10808874368 11237289984 1890508704 18.750 100 16 32 0 1900568800 5489664 4570432
17:17:37 8376 8192000000 10783964496 11208998912 1849040096 18.414 98 18 36 3 1860897584 5859728 5997760
17:17:52 10741 8192000000 10773429152 11205545984 1834005040 18.292 98 14 28 0 1843181648 5006672 4169936
17:18:09 11276 8192000000 10760903376 11190755328 1797944000 17.997 96 11 22 3 1806589312 5225072 3420240
17:18:30 61225 8192000000 10705707168 11110813696 1679630128 17.014 91 21 42 0 1691154592 5109712 6414752
17:19:38 3021 8192000000 10727479408 11136925696 1772314736 17.786 97 51 104 2 1793874304 7433456 14126112
17:19:48 13009 8192000000 10720738928 11144024064 1768696384 17.756 97 23 46 0 1781737056 6851664 6189008
17:20:09 5760 8192000000 10747555408 11159572480 1775545280 17.813 97 37 75 0 1792413280 6197728 10670272
17:20:21 2485 8192000000 10736886192 11142131712 1776792272 17.823 98 38 75 1 1794410160 7238896 10378992
17:20:30 5350 8192000000 10713132928 11123879936 1756589296 17.656 98 30 60 2 1772033808 6762528 8681984
17:20:41 6384 8192000000 10720005120 11138027520 1803242784 18.041 100 32 64 2 1820178640 7955872 8979984
17:20:55 7812 8192000000 10695853984 11105849344 1740815296 17.525 97 31 60 1 1756165408 5751344 9598768
17:21:09 5681 8192000000 10670280272 11076280320 1678418752 17.004 94 33 66 5 1693605776 5478192 9708832
17:21:22 6588 8192000000 10649322656 11053436928 1672337120 16.953 95 28 56 1 1686271232 5061856 8872256
17:21:39 4342 8192000000 10693456768 11107721216 1776012320 17.817 100 35 70 1 1793588256 7849760 9726176
17:21:49 8448 8192000000 10699045488 11110801408 1748122256 17.586 98 28 56 1 1761967552 5557984 8287312
17:22:06 8956 8192000000 10703488704 11117338624 1787486912 17.911 100 18 36 2 1798903776 5458688 5958176
17:22:21 9969 8192000000 10731063584 11150622720 1818714032 18.167 100 23 45 3 1831048688 5506096 6828560
17:22:38 7719 8192000000 10730418608 11157504000 1822243008 18.196 100 22 44 2 1834220464 5292032 6685424
17:22:52 7379 8192000000 10742792400 11168120832 1831293200 18.270 100 33 66 0 1847299696 5493872 10512624
17:23:06 18689 8192000000 10775271552 11182280704 1832888864 18.283 100 29 57 1 1847083056 6243600 7950592
17:23:31 52360 8192000000 10754043664 11180457984 1830747744 18.265 99 57 115 0 1856337072 6896928 18692400
17:24:30 12735 8192000000 10754203264 11184320512 1844733104 18.379 100 23 44 1 1856933664 5209616 6990944
17:24:49 7469 8192000000 10779148624 11195551744 1852315360 18.441 100 37 74 2 1868599024 6428560 9855104
17:25:03 4526 8192000000 10779768608 11197976576 1854563504 18.459 100 35 70 0 1872525376 8198656 9763216
17:25:16 7319 8192000000 10771606064 11197595648 1855266352 18.465 100 27 54 0 1869643344 6905696 7471296
17:25:30 8583 8192000000 10769106560 11193622528 1851191792 18.432 100 25 48 3 1863696832 5614544 6890496
17:25:46 5404 8192000000 10761775776 11190951936 1853305168 18.449 100 28 55 4 1867063632 5695936 8062528
17:26:02 7519 8192000000 10762074176 11196809216 1856341296 18.474 100 14 28 1 1866076096 5621728 4113072
17:26:17 5781 8192000000 10774913600 11204108288 1863822480 18.534 100 22 45 0 1876230832 5745488 6662864
17:26:32 7061 8192000000 10783319504 11211853824 1864397888 18.539 100 22 44 1 1876359408 5333712 6627808
17:26:46 10085 8192000000 10787482432 11211280384 1866089488 18.553 100 17 34 0 1876092784 5181328 4821968
17:27:03 10150 8192000000 10812024928 11233169408 1881093488 18.674 100 24 48 1 1897135600 9461712 6580400
17:27:20 5275 8192000000 10832173440 11243925504 1896531600 18.798 100 46 92 1 1916286736 5809008 13946128
17:27:34 20318 8192000000 10840372080 11257298944 1905311696 18.869 100 51 101 1 1926700224 7460352 13928176
17:28:03 12714 8192000000 10849569216 11266170880 1914094400 18.940 100 47 93 1 1934820416 8171568 12554448
17:28:23 13865 8192000000 10854647824 11268718592 1918801664 18.977 100 48 96 1 1945917840 13432080 13684096
17:28:44 102582 8192000000 10859457968 11293020160 1926102224 19.036 100 48 96 3 1952632560 12614864 13915472
17:30:36 32190 8192000000 10868977584 11297533952 1936434784 19.118 100 37 74 2 1957972816 11075152 10462880
17:31:15 14823 8192000000 10872681936 11307761664 1947166784 19.204 100 52 103 0 1976289664 13860672 15262208
17:31:38 15262 8192000000 10883982896 11316948992 1948472064 19.214 100 40 80 0 1973197408 13391856 11333488
17:32:01 7498 8192000000 10886966096 11317440512 1954607152 19.263 100 58 116 0 1981036416 9912416 16516848
17:32:17 3923 8192000000 10886046656 11310297088 1950090608 19.227 100 52 101 0 1974507952 9450752 14966592
17:32:28 2753 8192000000 10916266896 11324252160 1961776384 19.320 100 84 166 2 2000725696 14740208 24209104
17:32:40 21163 8192000000 10901104896 11329355776 1963658960 19.335 100 54 108 0 1990857920 11329328 15869632
17:33:12 5664 8192000000 10909936896 11330908160 1968257696 19.372 100 55 109 2 1995409616 12181280 14970640
17:33:37 9514 8192000000 10916069744 11346067456 1974403792 19.420 100 58 116 0 2005807872 15722608 15681472
17:33:55 10928 8192000000 10914135984 11337760768 1972452656 19.405 100 50 100 3 2001746944 15260384 14033904
17:34:17 2541 8192000000 10944105104 11360890880 1983698368 19.494 100 73 143 1 2022699696 18564176 20437152
17:34:28 24870 8192000000 10923655952 11352604672 1979806128 19.463 100 67 134 2 2019335280 20341744 19187408
17:35:01 5843 8192000000 10920081712 11353493504 1978196128 19.450 100 51 102 1 2012344592 19554992 14593472
17:35:14 7670 8192000000 10925227888 11350687744 1981170336 19.474 100 59 114 0 2016311056 18771168 16369552
17:35:39 30188 8192000000 10931456656 11365777408 1984578224 19.501 100 43 83 0 2015945808 19540608 11826976
17:36:28 8418 8192000000 10928961696 11363938304 1984769072 19.502 100 51 102 1 2023688304 24061040 14858192
17:36:45 5051 8192000000 10944836192 11369385984 1988470944 19.532 100 50 100 1 2027366000 23833056 15062000
17:37:01 24323 8192000000 10936256720 11369349120 1986890368 19.519 100 49 98 1 2027448208 25172656 15385184
17:37:35 28703 8192000000 10942858496 11384213504 1994871040 19.582 100 48 96 0 2035944864 26155696 14918128
17:38:20 10042 8192000000 10938839600 11375190016 1990070704 19.544 100 56 112 0 2033769776 26527456 17171616
17:38:38 5121 8192000000 10931945856 11356393472 1958900512 19.297 99 68 137 1 2006541472 27457632 20183328
17:38:51 4250 8192000000 10941392496 11364339712 1977160944 19.442 100 65 127 1 2024309712 28445568 18703200
17:39:03 3574 8192000000 10949784432 11365404672 1979664592 19.462 100 74 144 0 2029088240 28278032 21145616
17:39:16 5360 8192000000 10952959104 11371376640 1984573216 19.501 100 73 145 1 2036670704 30991280 21106208
17:39:28 5386 8192000000 10934118880 11360137216 1962106160 19.323 99 75 150 1 2015591808 31540560 21945088
17:39:43 5509 8192000000 10922067312 11353219072 1941634640 19.160 98 53 106 2 1988815920 31428768 15752512
17:39:57 8262 8192000000 10920135200 11358208000 1971825184 19.400 100 43 86 0 2012111088 26770480 13515424
17:40:13 4465 8192000000 10916532928 11347247104 1938349744 19.134 98 48 96 2 1981089648 28476832 14263072
17:40:25 3981 8192000000 10939677312 11366379520 1980003536 19.465 100 60 120 2 2028207120 30420304 17783280
17:40:36 7235 8192000000 10944255968 11366191104 1981476800 19.476 100 71 140 0 2032835904 30486992 20872112
17:40:50 6293 8192000000 10938990848 11367239680 1980064320 19.465 100 65 129 0 2031284048 31728448 19491280
17:41:04 17671 8192000000 10941575104 11368513536 1959619264 19.303 99 54 107 2 2009780288 34235168 15925856
17:41:28 16242 8192000000 10908538352 11339411456 1950719920 19.232 99 44 85 4 1999909664 35951888 13237856
17:41:55 11994 8192000000 10931235440 11354132480 1960892208 19.313 100 58 116 3 2012493056 33731040 17869808
17:42:15 5812 8192000000 10924883824 11349549056 1945145792 19.188 99 54 108 0 1997044128 34903536 16994800
17:42:27 4861 8192000000 10951082896 11370303488 1973029952 19.409 100 75 150 3 2032280864 37365488 21885424
17:42:40 5496 8192000000 10935008160 11357401088 1967260112 19.364 100 57 113 0 2019373776 33779232 18334432
17:42:53 7818 8192000000 10919274640 11347648512 1944083824 19.179 99 59 119 0 2001929040 39520048 18325168
17:43:09 12202 8192000000 10922062720 11342467072 1938797472 19.137 99 68 136 3 1999932336 39065312 22069552
17:43:30 5472 8192000000 10905779776 11328147456 1927245808 19.045 99 57 114 0 1984202448 38197072 18759568
17:43:44 12177 8192000000 10920794000 11345874944 1949710016 19.224 100 55 110 2 2004365008 37555904 17099088
17:44:05 11269 8192000000 10919905328 11342979072 1935446224 19.110 99 56 111 4 1991550528 38720032 17384272
17:44:26 8357 8192000000 10897064544 11330113536 1934618704 19.104 100 53 106 1 1992922144 41336832 16966608
17:44:43 1542 8192000000 10907800944 11325726720 1934459168 19.103 100 64 128 1 1992982560 39239424 19283968
17:44:54 7654 8192000000 10909862704 11330785280 1920734064 18.993 99 54 108 1 1978251136 40718832 16798240
17:45:10 3285 8192000000 10913166624 11329892352 1939691136 19.144 100 71 143 2 2002413056 40124576 22597344
17:45:21 9030 8192000000 10919182720 11335774208 1927748224 19.049 99 65 129 0 1989174064 41103856 20321984
17:45:38 8257 8192000000 10917525312 11341877248 1940971824 19.155 100 49 98 1 1998321392 41287328 16062240
17:45:54 3020 8192000000 10924313808 11340279808 1913295616 18.933 98 68 134 0 1979134208 44416224 21422368
17:46:05 2117 8192000000 10946553232 11360862208 1961761664 19.320 100 73 144 2 2030020976 45063168 23196144
17:46:16 2747 8192000000 10948357712 11359883264 1963162816 19.331 100 83 167 0 2036395920 46693584 26539520
17:46:26 1891 8192000000 10962766000 11371044864 1967605072 19.366 100 86 171 1 2042625712 48709648 26310992
17:46:36 2878 8192000000 10970708528 11378962432 1972389408 19.404 100 89 178 1 2052730576 52015360 28325808
17:46:48 3609 8192000000 10958852560 11365900288 1952037264 19.243 99 75 150 0 2029791024 53848656 23905104
17:47:02 5016 8192000000 10963486512 11376340992 1962964832 19.330 100 77 154 2 2044093088 56740656 24387600
17:47:18 5874 8192000000 10969617952 11380551680 1975929696 19.432 100 80 160 0 2050885840 50073600 24882544
17:47:32 2858 8192000000 10964164656 11379146752 1974194176 19.419 100 72 143 1 2047506032 50678256 22633600
17:47:42 5593 8192000000 10974940288 11393830912 1981589216 19.477 100 71 142 1 2055415056 51287472 22538368
17:47:56 1718 8192000000 10975787360 11385827328 1974237376 19.419 100 80 157 0 2050857072 52382592 24237104
17:48:05 4189 8192000000 10970199856 11385110528 1976246752 19.435 100 76 152 1 2054584320 54039872 24297696
17:48:17 4462 8192000000 10977850512 11387179008 1963232784 19.332 99 88 175 1 2046448304 56158752 27056768
17:48:28 3163 8192000000 10984565808 11387695104 1972740240 19.407 100 95 190 0 2061892672 58986992 30165440
17:48:38 2100 8192000000 10972647440 11382341632 1957803888 19.289 99 87 173 1 2045365664 60003952 27557824
17:48:46 1597 8192000000 10988510784 11394191360 1976460896 19.437 100 89 177 0 2066282320 61984592 27836832
17:48:54 4098 8192000000 10965492272 11376988160 1958797952 19.296 99 79 158 1 2046310096 63017920 24494224
17:49:07 2387 8192000000 10983618624 11399184384 1976438816 19.436 100 77 154 0 2065869744 63443152 25987776
17:49:19 1403 8192000000 10993157056 11401318400 1976617984 19.438 100 78 155 0 2066359216 64388064 25353168
17:49:27 3567 8192000000 10998441232 11411681280 1989346736 19.539 100 85 170 2 2077451744 61561184 26543824
17:49:52 10549 8192000000 10950240656 11396825088 1981027936 19.473 100 41 82 0 2041474768 45772352 14674480
17:50:16 15984 8192000000 10947380560 11382947840 1937161216 19.124 98 40 80 1 2000076112 48325712 14589184
17:50:40 13472 8192000000 10951359536 11390451712 1968881856 19.377 100 35 69 3 2030326016 49398864 12045296
17:51:01 16702 8192000000 10930211840 11374202880 1929836016 19.066 98 32 65 6 1992238384 50880800 11521568
17:51:24 17078 8192000000 10897963760 11347656704 1918525856 18.975 99 32 64 3 1976345488 47502720 10316912
17:51:55 11948 8192000000 10923072272 11360481280 1941178752 19.156 100 39 78 0 2003891216 49324448 13388016
17:52:15 3747 8192000000 10950131248 11374915584 1955786368 19.273 100 59 117 3 2026319232 51191072 19341792
17:52:26 11271 8192000000 10923949664 11370352640 1916256192 18.957 98 32 62 1 1979401360 52743424 10401744
17:52:44 14760 8192000000 10910097872 11349524480 1927224832 19.045 99 33 66 0 1980482944 42086064 11172048
17:53:11 19707 8192000000 10918084080 11353948160 1937580000 19.127 100 28 57 1 1994800352 47657424 9562928
17:53:46 18515 8192000000 10900681536 11352006656 1926090480 19.036 99 25 50 1 1982647152 48143600 8413072
17:54:25 38578 8192000000 10914509120 11364593664 1946868272 19.202 100 34 68 1 2001473664 43731920 10873472
17:55:30 23148 8192000000 10896551248 11342852096 1911206720 18.916 99 25 49 2 1966293776 46370384 8716672
17:55:59 14064 8192000000 10893405920 11345989632 1917100368 18.964 100 21 42 1 1976388096 51641040 7646688
17:56:21 19469 8192000000 10879929664 11345256448 1916847040 18.962 100 17 34 2 1969083488 45900336 6336112
17:56:54 14338 8192000000 10875643776 11326885888 1898788848 18.817 99 17 34 0 1946625360 42057664 5778848
17:57:16 12955 8192000000 10881906272 11329556480 1916904096 18.962 100 16 32 1 1963155328 40843728 5407504
17:57:35 64640 8192000000 10883267424 11324895232 1901844480 18.841 98 21 41 0 1920650720 13481008 5325232
17:58:46 40074 8192000000 10863627536 11308376064 1890045840 18.746 97 13 26 0 1900005744 6589872 3370032
17:59:37 26070 8192000000 10877447360 11331190784 1944051040 19.179 100 13 26 0 1953264288 5956880 3256368
18:00:09 14406 8192000000 10907109728 11344138240 1964438512 19.341 100 31 61 1 1979500496 6031232 9030752
18:00:32 41437 8192000000 10904935680 11355217920 1958231440 19.292 99 44 89 5 1980614080 10744976 11637664
18:01:33 35665 8192000000 10911378608 11361140736 1966611344 19.359 100 40 81 2 1993298096 14940432 11746320
18:02:35 48254 8192000000 10915946096 11361587200 1947119824 19.204 99 25 50 0 1972765888 18272816 7373248
18:03:30 54827 8192000000 10911399312 11364847616 1931002512 19.075 98 31 61 2 1963024304 23190944 8830848
18:04:34 140070 8192000000 10906434816 11372412928 1972678352 19.407 100 23 46 1 1998952992 19256624 7018016
18:07:03 137571 8192000000 10880334336 11348729856 1940849616 19.154 98 18 36 0 1955846256 9928384 5068256
18:09:27 28275 8192000000 10912791584 11364319232 1959141216 19.299 99 39 78 0 1978613824 8658960 10813648
18:10:08 35338 8192000000 10928085088 11379945472 1987485200 19.524 100 39 78 1 2010423664 11944304 10994160
18:10:54 22858 8192000000 10911493248 11383156736 1988230224 19.530 100 32 62 0 2012468016 15107376 9130416
18:11:23 41884 8192000000 10904519984 11370704896 1946057712 19.195 98 13 27 1 1962122240 12169936 3894592
18:12:30 52612 8192000000 10910427184 11379949568 1961745216 19.320 99 11 22 0 1979827856 14238800 3843840
18:13:40 36058 8192000000 10894415984 11369447424 1958146736 19.291 99 8 16 1 1972618576 12018272 2453568
18:14:55 11116 8192000000 10926561792 11374403584 1979900672 19.464 100 41 81 1 1997373568 6365504 11107392
18:15:21 17144 8192000000 10922568320 11381899264 1989764592 19.542 100 45 91 4 2009717536 7886176 12066768
18:15:51 98426 8192000000 10914108496 11387670528 1989013952 19.536 100 15 30 1 2000191456 7029936 4147568
18:17:46 54143 8192000000 10916443856 11377803264 1954600752 19.263 98 33 66 1 1971099968 7425344 9073872
18:18:47 24807 8192000000 10907742496 11369598976 1967306896 19.364 99 26 51 4 1983363984 9321360 6735728
18:19:19 25960 8192000000 10904850864 11383418880 1963358432 19.333 99 21 41 1 1985668624 16606736 5703456
18:19:59 63367 8192000000 10908150080 11382128640 1967143552 19.363 99 19 38 0 1983396688 10895376 5357760
18:21:10 53020 8192000000 10898658304 11388178432 1966082448 19.354 99 16 32 1 1985887216 15747312 4057456
18:22:09 35785 8192000000 10881591136 11360391168 1924545072 19.023 97 12 23 2 1934786656 7253088 2988496
18:22:58 45472 8192000000 10871044784 11333931008 1880360144 18.668 95 26 53 1 1896574160 8324128 7889888
18:23:57 63000 8192000000 10910288560 11377872896 1954501024 19.262 99 20 40 1 1978720672 18404016 5815632
18:25:15 50510 8192000000 10910537344 11383762944 1939805456 19.145 98 14 28 0 1966994736 22535488 4653792
18:26:21 66496 8192000000 10877013296 11351724032 1890348768 18.749 96 16 30 2 1908149024 12860384 4939872
18:27:40 60174 8192000000 10889859952 11349217280 1881893488 18.680 96 19 38 0 1899679936 12629728 5156720
18:28:52 61754 8192000000 10869802144 11335049216 1881260448 18.675 97 17 34 0 1902325680 16449648 4615584
18:30:00 87482 8192000000 10882484480 11348652032 1923387024 19.014 98 14 28 0 1937591568 10779552 3424992
18:31:39 58046 8192000000 10892578832 11338018816 1863301440 18.530 95 32 64 1 1881107568 8793824 9012304
18:32:44 25902 8192000000 10896326352 11327508480 1918482096 18.975 98 42 84 1 1943693296 13185328 12025872
18:33:23 35075 8192000000 10878336784 11346489344 1942756576 19.169 100 39 78 0 1966601184 13204656 10639952
18:34:50 122240 8192000000 10886144192 11342577664 1933587008 19.096 99 36 72 1 1955776912 12009984 10179920
18:36:59 56009 8192000000 10883935824 11354693632 1956033120 19.274 100 37 72 0 1979258144 13098816 10126208
18:38:02 46482 8192000000 10847787792 11311575040 1854511120 18.459 95 25 49 1 1872403456 10952640 6939696
18:38:56 52629 8192000000 10833056096 11310075904 1893780480 18.776 98 8 16 1 1907042112 11266896 1994736
18:40:00 40715 8192000000 10844534944 11323203584 1914229120 18.941 99 12 23 0 1928021584 10457472 3334992
18:40:53 37963 8192000000 10854059136 11325480960 1936449552 19.118 100 10 18 2 1948599952 9563328 2587072
18:41:42 25958 8192000000 10853046912 11329335296 1939981184 19.147 100 6 12 0 1953680384 11925648 1773552
18:42:19 58406 8192000000 10830761824 11312619520 1890391392 18.749 98 17 32 2 1905013872 10676720 3945760
18:43:24 65797 8192000000 10867731632 11340496896 1933407968 19.094 100 20 40 0 1947476848 8474672 5594208
18:44:36 64521 8192000000 10856816624 11322347520 1875953280 18.632 96 15 30 1 1893494800 13252464 4289056
18:45:47 71801 8192000000 10874207600 11344420864 1909880400 18.906 98 24 48 1 1932492208 15970192 6641616
18:47:09 73464 8192000000 10816788512 11278471168 1802106592 18.031 93 17 34 1 1817612016 11062624 4442800
18:48:32 20651 8192000000 10831258976 11283238912 1866660688 18.557 98 27 54 0 1883521392 9095568 7765136
18:49:02 23704 8192000000 10858753248 11296509952 1880965200 18.673 98 45 88 0 1904188864 10686480 12537184
18:49:32 71992 8192000000 10841072640 11312857088 1875612400 18.630 98 34 68 0 1900282160 15457568 9212192
18:50:50 129542 8192000000 10864339792 11341590528 1914213904 18.940 99 23 46 0 1933803136 13533168 6056064
18:53:10 103564 8192000000 10866251504 11336118272 1884688416 18.703 97 20 40 0 1902332320 12369136 5274768
18:55:00 92477 8192000000 10894326048 11373342720 1961973280 19.322 100 27 53 2 1982981136 12832336 8175520
18:56:39 76520 8192000000 10868882192 11343204352 1941163136 19.156 99 5 10 0 1958236576 16356400 717040
18:58:27 61200 8192000000 10885109776 11361177600 1968200464 19.371 100 19 38 2 1987757520 14613552 4943504
18:59:34 41874 8192000000 10895392816 11347140608 1950806256 19.233 99 33 66 0 1967144544 8308768 8029520
19:00:22 39243 8192000000 10871378448 11349864448 1951330240 19.237 99 30 60 0 1968822464 9126096 8366128
19:01:13 58790 8192000000 10884888176 11353792512 1960980352 19.314 99 21 40 1 1976442592 9948832 5513408
19:02:37 84106 8192000000 10881788016 11358830592 1890807296 18.752 96 9 18 0 1906995440 13775232 2412912
19:04:08 93518 8192000000 10878338624 11356397568 1899381136 18.821 97 8 16 1 1917162352 15580944 2200272
19:05:49 64122 8192000000 10896897488 11362484224 1934029648 19.099 98 25 50 2 1952615184 11257904 7327632
19:06:59 27024 8192000000 10923732960 11378036736 1963349648 19.333 99 45 90 0 1987834304 11638976 12845680
19:07:41 68531 8192000000 10917347248 11389964288 1976009616 19.433 100 19 38 0 2000203776 18796448 5397712
19:08:56 85661 8192000000 10875989008 11361751040 1909208848 18.900 97 9 18 1 1938294384 26550512 2535024
19:10:28 45226 8192000000 10888632912 11344257024 1948845520 19.217 99 23 45 1 1964673808 9567872 6260416
19:11:19 29269 8192000000 10887153696 11334098944 1885755088 18.712 96 36 72 1 1906839792 9788512 11296192
19:11:54 27053 8192000000 10864480464 11318812672 1890255216 18.748 97 25 50 0 1906526288 9262496 7008576
19:12:28 37392 8192000000 10871271024 11320627200 1911983328 18.923 98 38 74 1 1932007744 9852224 10172192
19:13:14 65874 8192000000 10868856560 11336151040 1892428976 18.765 97 35 70 3 1915417632 13276704 9711952
19:14:30 54610 8192000000 10872648000 11332214784 1887562160 18.726 97 20 40 0 1902972912 9776528 5634224
19:15:32 91567 8192000000 10878378432 11337895936 1838449792 18.328 94 24 49 0 1857901904 12468000 6984112
19:17:09 106128 8192000000 10870794224 11336794112 1926479280 19.039 99 13 24 0 1943605872 14016704 3109888
19:19:19 69078 8192000000 10871526144 11336138752 1910478752 18.910 98 20 40 0 1929271616 12906432 5886432
19:20:35 55482 8192000000 10893897728 11346165760 1936855456 19.122 99 36 72 3 1960321536 13434128 10031952
19:21:38 50573 8192000000 10874894096 11356372992 1939558192 19.143 99 22 44 0 1955379488 9641312 6179984
19:22:50 77068 8192000000 10893377568 11376103424 1960513536 19.310 100 11 22 0 1980748960 16761184 3474240
19:24:14 57554 8192000000 10879051840 11351388160 1927936976 19.050 98 10 20 0 1942191520 11142864 3111680
19:25:31 99593 8192000000 10882303248 11358347264 1930544032 19.071 98 18 36 0 1948017360 11850080 5623248

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:33, from 13-01-2021 19:29:33 to 13-01-2021 19:30:06.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 179 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:01, from 13-01-2021 19:30:07 to 13-01-2021 19:30:08.

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          242103
MON$OLDEST_ACTIVE               244587
MON$OLDEST_SNAPSHOT             244587
MON$NEXT_TRANSACTION            244587
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                       2030560
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.8.33402 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33402 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33402 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33402 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================

Database validation

Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test

--- start of diff output ---
:871: 
:872: mscs-test-161.budzdorov.ru    Wed Jan 13 19:27:34 2021
:873:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:874: 
:875: 
:876: mscs-test-161.budzdorov.ru    Wed Jan 13 19:27:35 2021
:877:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:878: 
:879: 
:880: mscs-test-161.budzdorov.ru    Wed Jan 13 19:27:35 2021
:881:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:882: 
--- end of diff output ---

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

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