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

Hardware and OS info

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

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-02-13 22:27:17
DTS_END                         2021-02-13 22:27:17.2080
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(39:5) ==> X_MAKE_QSTORNO_1200_2000(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/36412
TRN_ID                          243028
ATT_ID                          696
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: 9512.24 19620 1141469
customer order: creation 179.62 333 21554
customer order: refuse 15.72 336 1886
order to supplier: creation 46.16 1327 5539
order to supplier: removal 3.53 99730 423
invoice (draft): creation 46.51 3528 5581
invoice (draft): removal 52.16 814 6259
invoice accept: apply 43.58 20127 5230
invoice accept: cancel 47.54 834 5705
customer reserve: creation 4078.72 197 489446
customer reserve: removal 4699.52 59 563942
realization accept: apply 86.16 176 10339
realization accept: cancel 77.27 109 9272
payment from customer: creation 62.12 129 7454
payment from customer: removal 6.03 63 724
payment to supplier: creation 51.60 133 6192
payment to supplier: removal 3.32 78 398
service: total inventory turnovers 4.92 1076 590
service: total monetary turnovers 6.87 23 824
service: aggregate perf. data 0.89 19554 107
service: refresh index statistics 0.03 243779 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 13-02-2021 22:28:04 to 13-02-2021 22:28:06.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3102
TEST_TIME 2 3636
TEST_TIME 3 3925
TEST_TIME 4 3408
TEST_TIME 5 4417
TEST_TIME 6 5143
TEST_TIME 7 5346
TEST_TIME 8 5132
TEST_TIME 9 5277
TEST_TIME 10 6172
TEST_TIME 11 6271
TEST_TIME 12 6478
TEST_TIME 13 6619
TEST_TIME 14 6688
TEST_TIME 15 7120
TEST_TIME 16 7085
TEST_TIME 17 7211
TEST_TIME 18 7586
TEST_TIME 19 7849
TEST_TIME 20 7974
TEST_TIME 21 8123
TEST_TIME 22 8358
TEST_TIME 23 8541
TEST_TIME 24 8762
TEST_TIME 25 9115
TEST_TIME 26 9125
TEST_TIME 27 9162
TEST_TIME 28 9557
TEST_TIME 29 10330
TEST_TIME 30 10633
TEST_TIME 31 10525
TEST_TIME 32 10502
TEST_TIME 33 10511
TEST_TIME 34 10482
TEST_TIME 35 10350
TEST_TIME 36 10285
TEST_TIME 37 10146
TEST_TIME 38 9947
TEST_TIME 39 9832
TEST_TIME 40 9946
TEST_TIME 41 9957
TEST_TIME 42 9812
TEST_TIME 43 9790
TEST_TIME 44 9753
TEST_TIME 45 9844
TEST_TIME 46 9923
TEST_TIME 47 9995
TEST_TIME 48 9861
TEST_TIME 49 9904
TEST_TIME 50 9765
TEST_TIME 51 9736
TEST_TIME 52 9651
TEST_TIME 53 9651
TEST_TIME 54 9632
TEST_TIME 55 9516
TEST_TIME 56 9574
TEST_TIME 57 9518
TEST_TIME 58 9506
TEST_TIME 59 9478
TEST_TIME 60 9460
TEST_TIME 61 9487
TEST_TIME 62 9578
TEST_TIME 63 9565
TEST_TIME 64 9637
TEST_TIME 65 9731
TEST_TIME 66 9713
TEST_TIME 67 9747
TEST_TIME 68 9776
TEST_TIME 69 9916
TEST_TIME 70 9907
TEST_TIME 71 9884
TEST_TIME 72 9904
TEST_TIME 73 9875
TEST_TIME 74 9799
TEST_TIME 75 9786
TEST_TIME 76 9702
TEST_TIME 77 9691
TEST_TIME 78 9695
TEST_TIME 79 9667
TEST_TIME 80 9599
TEST_TIME 81 9554
TEST_TIME 82 9489
TEST_TIME 83 9520
TEST_TIME 84 9492
TEST_TIME 85 9498
TEST_TIME 86 9498
TEST_TIME 87 9529
TEST_TIME 88 9552
TEST_TIME 89 9565
TEST_TIME 90 9599
TEST_TIME 91 9600
TEST_TIME 92 9614
TEST_TIME 93 9656
TEST_TIME 94 9607
TEST_TIME 95 9724
TEST_TIME 96 9694
TEST_TIME 97 9616
TEST_TIME 98 9607
TEST_TIME 99 9571
TEST_TIME 100 9544
TEST_TIME 101 9547
TEST_TIME 102 9493
TEST_TIME 103 9459
TEST_TIME 104 9452
TEST_TIME 105 9396
TEST_TIME 106 9396
TEST_TIME 107 9414
TEST_TIME 108 9429
TEST_TIME 109 9430
TEST_TIME 110 9477
TEST_TIME 111 9444
TEST_TIME 112 9440
TEST_TIME 113 9446
TEST_TIME 114 9429
TEST_TIME 115 9476
TEST_TIME 116 9464
TEST_TIME 117 9495
TEST_TIME 118 9478
TEST_TIME 119 9547
TEST_TIME 120 9515

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 13-02-2021 22:28:08 to 13-02-2021 22:28:11.

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 1593009 1593009 0 0.00 0 20228 7 0 0
doc_list_biud 1593007 1593007 0 0.00 0 53698 27 0 0
sp_add_invoice_to_stock 5328 5230 98 1.83 39 224740 20128 0 98
sp_cancel_adding_invoice 5705 5705 0 0.00 5 57492 835 0 0
sp_cancel_client_order 1886 1886 0 0.00 4 14751 336 0 0
sp_cancel_customer_reserve 563942 563942 0 0.00 1 53701 60 0 0
sp_cancel_pay_from_customer 724 724 0 0.00 3 3124 63 0 0
sp_cancel_pay_to_supplier 398 398 0 0.00 3 1966 79 0 0
sp_cancel_supplier_invoice 6264 6259 5 0.07 2 17028 815 0 5
sp_cancel_supplier_order 423 423 0 0.00 7 983524 99730 0 0
sp_cancel_write_off 9272 9272 0 0.00 1 14958 110 0 0
sp_client_order 21554 21554 0 0.00 3 24627 334 0 0
sp_customer_reserve 489446 489446 0 0.00 0 79370 197 0 0
sp_fill_shopping_cart 32651 32651 0 0.00 1 10367 34 0 0
sp_fill_shopping_cart_clo_res 489442 489442 0 0.00 0 19665 14 0 0
sp_get_clo_for_invoice 5224 5224 0 0.00 0 25305 276 0 0
sp_kill_cost_storno 16099 16099 0 0.00 0 5766 56 0 0
sp_kill_qstorno_ret_qs2qd 1143838 1143838 0 0.00 0 53694 32 0 0
sp_kill_qty_storno 603049 603049 0 0.00 0 53698 70 0 0
sp_lock_selected_doc 21667 21667 0 0.00 0 8595 5 0 0
sp_make_cost_storno 29209 29209 0 0.00 0 19168 57 0 0
sp_multiply_rows_for_pdistr 29208 29208 0 0.00 0 6465 28 0 0
sp_multiply_rows_for_qdistr 21554 21554 0 0.00 0 18424 144 0 0
sp_pay_from_customer 7454 7454 0 0.00 4 24631 129 0 0
sp_pay_to_supplier 6192 6192 0 0.00 4 17891 133 0 0
sp_payment_common 13646 13646 0 0.00 1 22960 26 0 0
sp_qd_handle_on_cancel_clo 1886 1886 0 0.00 0 14743 301 0 0
sp_qd_handle_on_invoice_upd_sts 10928 10928 0 0.00 0 21034 324 0 0
sp_qd_handle_on_reserve_upd_sts 10339 10339 0 0.00 0 23092 56 0 0
sp_reserve_write_off 10339 10339 0 0.00 6 23108 177 0 0
sp_supplier_invoice 5581 5581 0 0.00 7 72048 3528 0 0
sp_supplier_order 5539 5539 0 0.00 6 44044 1328 0 0
srv_aggregate_perf_data 107 107 0 0.00 3037 178000 19555 0 0
srv_fill_mon_cache_memory 171 171 0 0.00 1671 140715 30508 0 0
srv_find_qd_qs_mism 1090655 1090655 0 0.00 0 8476 6 0 0
srv_make_invnt_saldo 590 590 0 0.00 48 80971 1076 0 0
srv_make_money_saldo 824 824 0 0.00 1 437 23 0 0
srv_recalc_idx_stat 4 4 0 0.00 173241 321042 243779 0 0
t$perf-abend:sp_add_invoice_to_stock 98 98 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 5 5 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5230 5230 0 0.00 0 14836 175 0 0
t$perf-norm:sp_cancel_adding_invoice 439 439 0 0.00 0 2027 74 0 0
t$perf-norm:sp_cancel_client_order 1886 1886 0 0.00 0 2930 13 0 0
t$perf-norm:sp_cancel_customer_reserve 787 787 0 0.00 0 5631 16 0 0
t$perf-norm:sp_cancel_pay_from_customer 724 724 0 0.00 0 3258 9 0 0
t$perf-norm:sp_cancel_pay_to_supplier 398 398 0 0.00 0 4898 22 0 0
t$perf-norm:sp_cancel_supplier_invoice 411 411 0 0.00 0 3287 26 0 0
t$perf-norm:sp_cancel_supplier_order 423 423 0 0.00 0 24307 1641 0 0
t$perf-norm:sp_cancel_write_off 1037 1037 0 0.00 0 1943 9 0 0
t$perf-norm:sp_client_order 21554 21554 0 0.00 0 10035 16 0 0
t$perf-norm:sp_customer_reserve 1108 1108 0 0.00 0 2041 4 0 0
t$perf-norm:sp_pay_from_customer 7454 7454 0 0.00 0 3745 10 0 0
t$perf-norm:sp_pay_to_supplier 6192 6192 0 0.00 0 6817 8 0 0
t$perf-norm:sp_reserve_write_off 10339 10339 0 0.00 0 7748 12 0 0
t$perf-norm:sp_supplier_invoice 5581 5581 0 0.00 0 7326 22 0 0
t$perf-norm:sp_supplier_order 5539 5539 0 0.00 0 5689 18 0 0
t$perf-norm:srv_aggregate_perf_data 107 107 0 0.00 0 489 16 0 0
t$perf-norm:srv_fill_mon_cache_memory 171 171 0 0.00 0 368 6 0 0
t$perf-norm:srv_make_invnt_saldo 590 590 0 0.00 0 2229 34 0 0
t$perf-norm:srv_make_money_saldo 824 824 0 0.00 0 1062 13 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 10 4 0 0
v_add_invoice_to_stock 10642 10446 196 1.84 0 8349 18 0 196
v_all_customers 39606 39606 0 0.00 0 16 1 0 0
v_all_suppliers 31322 31322 0 0.00 0 128 1 0 0
v_all_wares 43108 43108 0 0.00 0 18 1 0 0
v_cancel_adding_invoice 878 878 0 0.00 0 20888 34 0 0
v_cancel_client_order 3772 3772 0 0.00 0 3745 7 0 0
v_cancel_customer_prepayment 1448 1448 0 0.00 0 3065 8 0 0
v_cancel_customer_reserve 1574 1574 0 0.00 0 1264 7 0 0
v_cancel_payment_to_supplier 796 796 0 0.00 0 1723 7 0 0
v_cancel_supplier_invoice 832 822 10 1.20 0 2029 21 0 10
v_cancel_supplier_order 846 846 0 0.00 0 2772 11 0 0
v_cancel_write_off 2074 2074 0 0.00 0 5228 19 0 0
v_max_id_clo_ord 5534 5534 0 0.00 0 543 1 0 0
v_max_id_clo_res 1108 1108 0 0.00 0 2915 14 0 0
v_max_id_ord_sup 5563 5563 0 0.00 0 3630 4 0 0
v_max_non_paid_invoice 1628 1628 0 0.00 0 418 3 0 0
v_max_non_paid_realizn 3947 3947 0 0.00 0 5240 4 0 0
v_min_id_clo_ord 5534 5534 0 0.00 0 1636 5 0 0
v_min_id_clo_res 1108 1108 0 0.00 0 5633 10 0 0
v_min_id_ord_sup 5563 5563 0 0.00 0 2791 5 0 0
v_min_non_paid_invoice 6192 6192 0 0.00 0 14770 15 0 0
v_min_non_paid_realizn 7454 7454 0 0.00 0 4871 15 0 0
v_our_firm 10516 10516 0 0.00 0 14 1 0 0
v_reserve_write_off 20678 20678 0 0.00 0 20871 9 0 0
x_lock_depdocs_on_canc_invoice 11553 11553 0 0.00 0 33053 113 0 0
x_lock_depdocs_on_canc_sup_ord 423 423 0 0.00 0 16951 450 0 0
x_make_qstorno_1000_1200 5539 5539 0 0.00 2 43999 1251 0 0
x_make_qstorno_1200_2000 5581 5581 0 0.00 3 71518 3407 0 0
x_make_qstorno_2100_3300 489446 489446 0 0.00 0 79360 180 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 13-02-2021 22:28:12 to 13-02-2021 22:28:16.

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:20 1 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
19:57:27 10276 8192000000 10190958976 10486046720 800254016 8.899 66 58 115 1 822688368 2286352 20148000
19:57:44 16321 8192000000 10272503232 10584125440 1316337312 13.844 100 80 158 1 1346490896 3923696 26229888
19:58:09 36174 8192000000 10349493488 10666795008 1393282384 14.535 100 85 169 1 1427254320 5755872 28216064
19:58:54 21516 8192000000 10381426224 10702835712 1430054880 14.862 100 93 186 1 1467812368 7071232 30686256
19:59:24 30932 8192000000 10404412512 10730446848 1455678368 15.088 100 91 182 0 1494355104 8385712 30291024
20:00:08 11267 8192000000 10414367136 10743713792 1475837408 15.265 100 90 180 1 1514265248 8902384 29525456
20:00:28 21774 8192000000 10433667824 10763505664 1487003408 15.363 100 91 182 0 1526156448 9475696 29677344
20:01:01 25009 8192000000 10446915696 10783748096 1501801584 15.492 100 84 168 0 1538351408 9566832 26982992
20:01:44 18678 8192000000 10468016480 10811891712 1529902320 15.736 100 83 166 1 1565868848 10065264 25901264
20:02:10 11885 8192000000 10486942320 10834366464 1543091744 15.850 100 73 145 2 1575134896 9628640 22414512
20:02:31 18690 8192000000 10527971968 10881343488 1573657744 16.114 100 74 148 0 1606677728 9826064 23193920
20:02:57 15574 8192000000 10558644800 10917998592 1617712112 16.490 100 73 146 0 1650228272 10377408 22138752
20:03:22 11563 8192000000 10586070624 10953375744 1648515328 16.752 100 76 151 4 1682396800 11451184 22430288
20:03:42 10693 8192000000 10627111792 10995535872 1681574128 17.031 100 71 142 2 1713331296 11554144 20203024
20:03:59 7779 8192000000 10635964960 11009859584 1703454592 17.214 100 82 162 0 1742282112 15560224 23267296
20:04:15 9132 8192000000 10651183552 11028107264 1718853328 17.343 100 82 164 2 1755343840 12895376 23595136
20:04:32 5466 8192000000 10663317712 11039506432 1727115104 17.411 100 82 162 1 1762702448 12630400 22956944
20:04:45 7460 8192000000 10671218016 11052777472 1734847248 17.476 100 73 146 0 1768092000 12191088 21053664
20:05:00 5637 8192000000 10685052864 11060740096 1747333856 17.579 100 76 152 1 1781524640 12880464 21310320
20:05:13 4183 8192000000 10687580288 11072266240 1760554384 17.689 100 77 154 2 1794733840 12367312 21812144
20:05:25 3319 8192000000 10706941680 11085516800 1768302736 17.753 100 76 153 1 1801371824 12661072 20408016
20:05:37 4620 8192000000 10710563856 11090792448 1775942400 17.816 100 67 133 2 1806427536 12226736 18258400
20:05:49 3510 8192000000 10732818176 11111690240 1790927984 17.939 100 86 172 0 1828199408 12819952 24451472
20:05:59 14668 8192000000 10723790608 11112464384 1792092016 17.949 100 67 134 0 1822699904 12503616 18104272
20:06:21 3933 8192000000 10750305040 11138551808 1807421488 18.075 100 82 164 0 1844325200 12809136 24094576
20:06:35 2347 8192000000 10756351488 11144847360 1821246048 18.188 100 84 168 1 1858926624 13253744 24426832
20:06:44 3417 8192000000 10762766176 11154468864 1823433184 18.206 100 81 162 3 1859010864 13363776 22213904
20:06:55 3043 8192000000 10761453776 11152506880 1830392384 18.263 100 85 170 1 1865966752 11806928 23767440
20:07:06 3839 8192000000 10774410752 11161321472 1834557536 18.296 100 77 155 1 1868148848 12080720 21510592
20:07:16 1387 8192000000 10783500928 11166294016 1838658944 18.330 100 88 174 2 1876930048 13626464 24644640
20:07:24 1874 8192000000 10785258768 11171819520 1840535136 18.345 100 92 184 5 1881028112 14462560 26030416
20:07:33 2623 8192000000 10785041488 11173130240 1847416800 18.401 100 89 178 3 1884873856 13256672 24200384
20:07:42 2808 8192000000 10792319904 11180081152 1849987184 18.422 100 93 185 4 1888984896 13311184 25686528
20:07:52 2666 8192000000 10802048112 11185655808 1851472864 18.434 100 94 186 0 1892992112 15544544 25974704
20:08:00 2606 8192000000 10803942752 11191795712 1856143904 18.472 100 89 178 1 1894469712 13742512 24583296
20:08:10 1851 8192000000 10799946560 11187519488 1854046496 18.455 100 88 177 1 1892755440 14678080 24030864
20:08:19 1505 8192000000 10804601408 11189567488 1856991232 18.479 100 91 183 1 1896967520 14847456 25128832
20:08:27 3220 8192000000 10801553600 11192279040 1856176208 18.472 100 87 174 1 1895332032 13928080 25227744
20:08:37 1399 8192000000 10802637184 11193479168 1860305344 18.506 100 94 188 1 1900807216 14229728 26272144
20:08:45 1617 8192000000 10800552656 11189596160 1858865600 18.494 100 84 165 3 1894010832 11433120 23712112
20:08:53 2487 8192000000 10805078816 11196182528 1864604176 18.541 100 91 181 2 1902504544 11716800 26183568
20:09:02 6325 8192000000 10809790960 11200684032 1865605264 18.549 100 85 167 2 1902123472 12758928 23759280
20:09:15 1269 8192000000 10813601360 11203731456 1869555216 18.581 100 89 177 1 1907992512 13102912 25334384
20:09:23 2435 8192000000 10803919680 11201949696 1867680560 18.566 100 85 169 1 1904917168 13162368 24074240
20:09:33 13645 8192000000 10811363936 11201155072 1869385680 18.579 100 84 169 1 1905033952 11704352 23943920
20:09:53 2236 8192000000 10802386512 11201331200 1870033040 18.585 100 79 154 2 1902400736 10946336 21421360
20:10:02 4707 8192000000 10821117056 11210035200 1871827456 18.599 100 83 166 1 1908148224 13085664 23235104
20:10:14 1911 8192000000 10818530336 11211706368 1877440720 18.644 100 91 180 0 1914690064 12658640 24590704
20:10:22 2844 8192000000 10803396832 11209740288 1872029712 18.601 100 67 134 2 1904456080 13953232 18473136
20:10:32 5338 8192000000 10781372704 11199778816 1870677616 18.590 100 49 98 1 1894822784 9958832 14186336
20:10:45 3005 8192000000 10791192032 11202387968 1874040208 18.617 100 48 96 1 1896700112 9196688 13463216
20:10:54 2959 8192000000 10800327728 11211612160 1876242848 18.635 100 48 95 1 1898476528 9114608 13119072
20:11:04 3143 8192000000 10798513136 11209486336 1879052672 18.657 100 63 127 0 1907434912 10148496 18233744
20:11:14 4261 8192000000 10792279120 11214139392 1876136736 18.634 100 38 76 2 1894805632 8677200 9991696
20:11:25 4412 8192000000 10800657824 11208126464 1878317072 18.652 100 41 81 2 1898789328 9629648 10842608
20:11:36 4464 8192000000 10800111696 11213099008 1880807136 18.672 100 34 67 4 1897073360 7132576 9133648
20:11:47 4948 8192000000 10791542272 11213209600 1880905728 18.672 100 41 78 0 1899598992 8075312 10617952
20:12:00 3192 8192000000 10798356336 11217616896 1881409664 18.676 100 41 81 1 1901799872 8836720 11553488
20:12:11 4608 8192000000 10798779040 11226009600 1880889744 18.672 100 27 52 1 1899035152 10892272 7253136
20:12:22 8583 8192000000 10788343616 11216113664 1882688640 18.687 100 34 68 0 1899043408 6846160 9508608
20:12:37 3769 8192000000 10788882512 11217604608 1883819472 18.696 100 23 46 0 1897436832 7019392 6597968
20:12:51 5998 8192000000 10795290672 11220451328 1884515488 18.702 100 19 38 1 1896370480 5533264 6321728
20:13:04 7570 8192000000 10795700160 11224027136 1888964256 18.737 100 28 56 1 1903348832 6473376 7911200
20:13:18 53808 8192000000 10812222224 11233370112 1893665040 18.775 100 26 51 4 1907409712 4769456 8975216
20:14:23 14539 8192000000 10827933072 11251679232 1898035200 18.810 100 25 50 0 1911339424 6453424 6850800
20:14:44 5142 8192000000 10821073696 11252183040 1898535264 18.815 100 31 62 1 1914962176 8172464 8254448
20:14:55 6432 8192000000 10815703920 11246178304 1898826448 18.817 100 28 54 3 1912036896 4808896 8401552
20:15:10 10595 8192000000 10807101104 11235917824 1875086368 18.625 99 19 38 3 1885714512 5154432 5473712
20:15:26 5738 8192000000 10812002208 11242147840 1893810816 18.776 100 28 56 0 1908600512 6884928 7904768
20:15:38 7974 8192000000 10790368176 11224543232 1871265296 18.595 99 16 32 1 1881482480 5562304 4654880
20:15:55 5655 8192000000 10819884848 11246481408 1893695120 18.776 100 29 58 1 1908687200 7268288 7723792
20:16:07 7871 8192000000 10803725808 11240988672 1896274224 18.796 100 24 48 1 1909779664 6307472 7197968
20:16:24 11573 8192000000 10809703616 11250094080 1899212176 18.820 100 12 24 2 1908163520 5648256 3303088
20:16:41 4928 8192000000 10814663296 11249373184 1898548912 18.815 100 26 52 2 1912798096 6987552 7261632
20:16:53 15182 8192000000 10808911232 11242344448 1864193728 18.537 98 21 42 1 1875939408 5189008 6556672
20:17:17 7796 8192000000 10815830448 11245719552 1885665408 18.711 99 31 62 0 1901671504 6545056 9461040
20:17:32 8189 8192000000 10801380432 11236298752 1873641120 18.614 99 17 34 1 1884088112 5536304 4910688
20:17:47 9141 8192000000 10785313616 11210788864 1827648080 18.240 97 17 34 0 1842282720 10036320 4598320
20:18:02 7539 8192000000 10797978704 11220226048 1862327040 18.522 99 20 39 1 1874248224 6269376 5651808
20:18:18 59329 8192000000 10776077600 11195682816 1819866192 18.177 97 26 52 1 1832579856 5387984 7325680
20:19:32 15706 8192000000 10759507792 11166830592 1690919920 17.109 90 40 80 1 1708410736 6635680 10855136
20:19:58 5573 8192000000 10766507088 11183747072 1844691008 18.379 100 42 84 0 1864414688 8284864 11438816
20:20:12 5606 8192000000 10756350960 11178749952 1828617184 18.248 99 34 67 3 1845266768 6522240 10127344
20:20:25 4921 8192000000 10745097216 11165507584 1789533216 17.928 97 27 54 2 1804235984 6782528 7920240
20:20:36 8627 8192000000 10753920272 11171450880 1817709552 18.159 99 21 42 1 1829850368 5791488 6349328
20:20:54 5209 8192000000 10755563392 11175981056 1826178208 18.228 99 34 66 1 1842158736 6363328 9617200
20:21:10 6548 8192000000 10721104112 11124781056 1783306640 17.877 97 28 54 4 1798501456 5859600 9335216
20:21:25 4971 8192000000 10732844624 11150184448 1801592240 18.027 99 32 63 2 1817299568 6604416 9102912
20:21:38 9864 8192000000 10682508688 11100549120 1725337264 17.397 96 19 38 1 1736633152 5778704 5517184
20:21:56 14086 8192000000 10698042448 11117793280 1738689616 17.508 97 17 34 0 1749592032 5940384 4962032
20:22:16 2024 8192000000 10717850960 11124989952 1792607424 17.953 100 45 92 1 1811630352 6247232 12775696
20:22:28 11296 8192000000 10696326544 11116445696 1733651216 17.466 96 25 46 3 1744915472 4647712 6616544
20:22:46 8163 8192000000 10711927104 11132493824 1778721952 17.839 99 15 30 1 1788965712 5861152 4382608
20:23:03 73632 8192000000 10730653216 11155914752 1777363584 17.828 97 38 76 2 1795534368 6221232 11949552
20:24:23 15883 8192000000 10736433952 11149570048 1792685568 17.954 98 23 46 2 1804901424 5636064 6579792
20:24:47 7095 8192000000 10744392624 11167571968 1833510352 18.288 100 42 84 3 1852299888 6676960 12112576
20:25:03 5018 8192000000 10756585840 11177263104 1839673232 18.338 100 41 82 1 1858966112 6918032 12374848
20:25:15 5417 8192000000 10754906640 11183968256 1840642352 18.346 100 27 54 1 1855687456 6998624 8046480
20:25:27 7905 8192000000 10766239664 11186053120 1843160960 18.367 100 24 48 0 1856192608 6157824 6873824
20:25:43 6957 8192000000 10759312064 11189997568 1851990864 18.438 100 20 40 2 1863071264 5877152 5203248
20:25:57 9228 8192000000 10778094656 11201069056 1856894176 18.478 100 22 44 1 1869701280 6394288 6412816
20:26:13 15085 8192000000 10770325664 11201085440 1862179360 18.521 100 17 34 0 1873278800 5910368 5189072
20:26:34 8277 8192000000 10783502208 11210399744 1863844144 18.534 100 22 44 0 1876160192 6472800 5843248
20:26:54 6293 8192000000 10797240688 11214872576 1870569616 18.589 100 25 50 0 1884042112 5500032 7972464
20:27:09 25244 8192000000 10807027856 11231399936 1885220640 18.707 100 26 52 0 1897680192 5083552 7376000
20:28:00 30788 8192000000 10842676768 11256193024 1905032640 18.867 100 43 86 1 1924119232 6791744 12294848
20:28:47 16105 8192000000 10862065664 11272835072 1921062752 18.995 100 60 118 0 1947410304 9656288 16691264
20:29:14 59179 8192000000 10854210960 11275825152 1925837920 19.034 100 63 126 1 1954036112 10666096 17532096
20:30:19 44430 8192000000 10857726128 11291877376 1927566384 19.047 100 32 64 0 1951114944 14461712 9086848
20:31:12 23544 8192000000 10858526368 11292819456 1932793040 19.089 100 37 74 2 1954525888 10869424 10863424
20:31:44 27897 8192000000 10871786128 11303219200 1940639760 19.152 100 45 90 2 1964962064 11815984 12506320
20:32:21 10224 8192000000 10880610128 11308433408 1941725616 19.161 100 41 82 0 1970395680 16779184 11890880
20:32:39 14528 8192000000 10883465392 11313000448 1947281808 19.205 100 46 92 1 1976654032 15527248 13844976
20:33:03 6548 8192000000 10889479040 11314663424 1952501728 19.246 100 52 105 2 1982038416 14120240 15416448
20:33:22 8852 8192000000 10903083024 11322429440 1956915232 19.282 100 56 111 1 1986299008 13356704 16027072
20:33:39 1842 8192000000 10917617632 11327119360 1965562800 19.350 100 84 164 0 2002830416 14045952 23221664
20:33:47 9648 8192000000 10909522432 11329638400 1964848896 19.345 100 61 122 1 1997442304 14997952 17595456
20:34:05 2735 8192000000 10915324048 11332292608 1968040144 19.370 100 67 134 1 2004089328 16720160 19329024
20:34:17 11240 8192000000 10908576560 11341185024 1968863056 19.376 100 58 116 1 2001644816 16188464 16593296
20:34:41 8951 8192000000 10911434320 11341836288 1972226576 19.403 100 49 98 2 2001678048 15287328 14164144
20:35:04 8595 8192000000 10922366784 11349417984 1972333904 19.404 100 50 98 1 2001326512 14559456 14433152
20:35:20 9149 8192000000 10923986720 11350859776 1981161968 19.474 100 63 125 1 2016452752 16267488 19023296
20:35:37 13956 8192000000 10930582608 11357487104 1979532128 19.461 100 56 110 2 2013792000 17392752 16867120
20:36:00 11239 8192000000 10914392832 11346665472 1943902960 19.178 98 50 100 1 1976919440 18262096 14754384
20:36:38 15070 8192000000 10927209104 11358777344 1974518368 19.421 100 44 87 1 2009174896 20489952 14166576
20:37:00 10384 8192000000 10943631760 11375329280 1990171888 19.545 100 52 101 1 2030507280 24370736 15964656
20:37:18 3574 8192000000 10953446544 11381436416 1995937488 19.591 100 59 118 2 2040064656 26000432 18126736
20:37:30 10461 8192000000 10953217984 11376742400 1993703184 19.573 100 67 134 2 2036991248 22479472 20808592
20:37:49 5117 8192000000 10930836032 11356397568 1966914384 19.361 99 52 104 2 2002424848 19398528 16111936
20:38:02 9772 8192000000 10933990000 11368488960 1988874864 19.535 100 58 116 1 2023867888 18517840 16475184
20:38:23 6545 8192000000 10937451200 11364454400 1989704032 19.541 100 68 132 1 2028148480 19291280 19153168
20:38:38 5213 8192000000 10953860960 11377909760 1999200688 19.616 100 72 145 3 2041875056 21569680 21104688
20:38:51 5392 8192000000 10965498032 11385991168 2003318000 19.649 100 83 166 2 2052471312 23631280 25522032
20:39:03 2674 8192000000 10948930784 11362852864 1984101552 19.497 99 80 161 1 2029041840 21246768 23693520
20:39:13 5252 8192000000 10962843392 11381850112 2000933776 19.630 100 78 156 0 2044381920 20991552 22456592
20:39:26 6354 8192000000 10960162480 11379888128 2004853632 19.661 100 73 143 0 2046738832 21470656 20414544
20:39:39 10395 8192000000 10960967152 11388436480 2007672576 19.683 100 68 136 2 2049524512 21447312 20404624
20:40:04 3240 8192000000 10962007360 11375341568 1992219680 19.561 99 76 152 0 2037766368 23308896 22237792
20:40:14 3956 8192000000 10972066240 11397423104 2009576512 19.698 100 71 140 3 2056275296 26252528 20446256
20:40:27 3154 8192000000 10977605472 11407220736 2016106176 19.750 100 68 136 1 2062384544 25705488 20572880
20:40:37 6324 8192000000 10980832848 11399323648 2009537408 19.698 100 79 159 0 2060525536 27563248 23424880
20:40:52 3125 8192000000 10956485456 11376611328 1986350224 19.515 99 71 142 0 2038129088 30966480 20812384
20:41:03 6328 8192000000 10966027168 11388821504 1995377408 19.586 100 72 144 3 2049651456 32504176 21769872
20:41:17 3201 8192000000 10976846912 11398885376 2005517632 19.666 100 71 142 1 2060764208 33526432 21720144
20:41:28 2317 8192000000 10991232240 11408183296 2014178224 19.734 100 84 164 1 2074300192 34280128 25841840
20:41:37 3068 8192000000 10998135424 11417096192 2019311584 19.775 100 87 174 1 2082033680 35695568 27026528
20:41:50 4108 8192000000 10996765024 11415678976 2016611472 19.754 100 82 161 4 2078009792 36297808 25100512
20:42:01 2074 8192000000 10990311712 11409743872 2009066144 19.694 100 81 161 1 2071508592 38232032 24210416
20:42:10 2996 8192000000 10985274080 11403796480 2006988976 19.678 100 81 161 1 2067099632 35112112 24998544
20:42:24 3717 8192000000 10976066928 11395391488 1998652064 19.612 100 80 160 1 2058163968 35074640 24437264
20:42:35 5665 8192000000 10965159936 11379646464 1975595072 19.430 99 74 147 2 2032260656 34040032 22625552
20:42:48 3418 8192000000 10960021120 11378450432 1982811568 19.487 100 84 165 0 2041115264 32973296 25330400
20:42:58 1920 8192000000 10986559008 11398955008 2001346304 19.633 100 94 185 2 2065832640 35862096 28624240
20:43:11 4569 8192000000 10969965856 11391406080 1992043680 19.560 100 75 150 2 2051978656 37297104 22637872
20:43:25 7154 8192000000 10940935552 11360112640 1966091968 19.354 99 71 142 2 2026247072 38008128 22146976
20:43:40 3187 8192000000 10955150832 11376025600 1976856352 19.440 100 72 144 0 2038910448 38564224 23489872
20:43:52 7245 8192000000 10964233280 11385196544 1987023584 19.520 100 71 142 0 2048095920 38874800 22197536
20:44:10 3962 8192000000 10975526944 11398668288 1992773152 19.566 100 67 132 1 2055472384 41483072 21216160
20:44:22 4105 8192000000 10980845024 11404161024 1999361664 19.618 100 72 145 2 2066150400 43850320 22938416
20:44:34 11571 8192000000 10973160480 11401392128 1993131072 19.569 100 61 122 2 2055077280 41793408 20152800
20:44:54 5723 8192000000 10981924672 11411333120 2005370848 19.665 100 68 136 1 2072004448 45134064 21499536
20:45:07 11676 8192000000 10993811648 11422720000 2008457120 19.689 100 65 129 1 2075418624 46765952 20195552
20:45:25 2009 8192000000 10988189104 11404353536 1990023040 19.544 99 80 159 1 2063401184 47703568 25674576
20:45:36 2592 8192000000 10997751808 11418087424 2005241680 19.664 100 90 180 1 2082040096 49037648 27760768
20:45:47 1671 8192000000 10956792704 11365486592 1950918032 19.234 97 82 161 2 2025296304 48767152 25611120
20:45:56 2917 8192000000 10991771200 11405729792 1994937120 19.583 100 83 160 2 2063850400 43343056 25570224
20:46:06 7570 8192000000 10975934960 11397009408 1995035664 19.584 100 77 154 1 2061074800 42337920 23701216
20:46:25 4115 8192000000 10983246848 11403284480 2000080928 19.623 100 77 152 0 2070876864 48177328 22618608
20:46:40 3117 8192000000 10973741264 11393404928 1977538896 19.445 99 75 148 2 2044359504 43738144 23082464
20:46:50 3759 8192000000 10979804832 11395600384 1994650640 19.581 100 84 168 2 2062835344 41561232 26623472
20:47:04 4731 8192000000 10977619248 11394224128 1991542784 19.556 100 74 148 3 2054780288 40952832 22284672
20:47:18 3650 8192000000 10984790096 11405336576 2000896768 19.630 100 79 154 2 2065926032 41809296 23219968
20:47:30 2149 8192000000 10973171824 11389194240 1983954352 19.496 99 68 136 1 2047362800 43057408 20351040
20:47:39 2007 8192000000 10987453600 11407294464 1998445600 19.610 100 79 158 2 2066641952 44442832 23753520
20:47:51 12044 8192000000 10961674832 11405926400 1996730992 19.597 100 52 104 2 2057041744 43875808 16434944
20:48:14 9926 8192000000 10968443200 11404836864 1983379904 19.491 99 42 84 2 2040951200 44312800 13258496
20:48:43 11212 8192000000 10963488544 11411300352 1996549392 19.596 100 39 79 0 2052187328 43033888 12604048
20:49:04 4032 8192000000 10961582816 11383361536 1960992528 19.314 99 54 107 2 2022595120 43615328 17987264
20:49:18 18637 8192000000 10942590960 11387273216 1939246224 19.141 98 39 78 0 2001379616 49150944 12982448
20:49:49 15650 8192000000 10933672720 11376881664 1964243872 19.340 100 34 68 3 2024593168 49094976 11254320
20:50:12 9882 8192000000 10927542320 11361243136 1913960608 18.938 97 43 86 1 1977584640 49313632 14310400
20:50:42 10078 8192000000 10935879776 11369390080 1937623312 19.128 99 43 86 0 2002345856 50475472 14247072
20:51:00 4413 8192000000 10947116592 11371040768 1959141328 19.299 100 45 90 1 2021318672 46980128 15197216
20:51:15 4914 8192000000 10960386368 11376963584 1955855920 19.273 99 69 135 0 2030778816 51637744 23285152
20:51:37 9429 8192000000 10930712624 11362275328 1950610000 19.231 100 49 97 1 2017415056 51030960 15774096
20:51:53 11637 8192000000 10940493584 11376427008 1952387520 19.245 100 31 62 1 2017712320 54375696 10949104
20:52:14 24715 8192000000 10948479808 11388125184 1956293392 19.277 100 33 66 2 2026645520 58787568 11564560
20:52:55 20611 8192000000 10923123536 11370733568 1948934016 19.218 100 31 62 0 2007996544 48440768 10621760
20:54:01 28719 8192000000 10912580848 11356270592 1932249680 19.085 100 27 54 1 1994365056 52311744 9803632
20:54:36 19700 8192000000 10929394064 11377610752 1946776368 19.201 100 36 72 1 2014213056 55522880 11913808
20:55:05 27813 8192000000 10900005856 11360927744 1922509216 19.007 99 20 40 1 1975456032 45529024 7417792
20:55:46 48746 8192000000 10882476688 11356872704 1915680448 18.952 99 16 32 1 1973490304 51147664 6662192
20:56:48 58198 8192000000 10866730064 11327229952 1882956976 18.689 97 9 18 0 1901449776 16462320 2030480
20:57:53 12944 8192000000 10891136256 11320971264 1915621840 18.952 98 49 98 3 1933237680 4844192 12771648
20:58:13 30960 8192000000 10855328992 11307945984 1901545920 18.839 98 12 23 2 1912593808 8010704 3037184
20:58:57 28839 8192000000 10875609376 11323125760 1929413264 19.062 99 22 44 1 1944763088 8908464 6441360
20:59:36 31909 8192000000 10880349376 11337437184 1926648816 19.040 99 12 24 0 1941457344 11693024 3115504
21:00:18 64426 8192000000 10881029840 11303952384 1852800560 18.445 95 25 44 0 1871434128 13510000 5123568
21:01:38 62054 8192000000 10863562032 11309174784 1883397984 18.693 97 14 27 1 1895567280 8594608 3574688
21:02:53 35720 8192000000 10907040784 11334651904 1950385936 19.230 100 44 88 2 1975107088 11986784 12734368
21:03:36 140714 8192000000 10908300352 11359461376 1964709632 19.343 100 43 86 0 1985667904 9425664 11532608
21:06:47 77372 8192000000 10906988864 11353903104 1918683520 18.976 98 21 42 2 1940502560 15100864 6718176
21:08:13 28143 8192000000 10914798736 11358679040 1961817312 19.320 100 40 80 1 1992413168 19743888 10851968
21:08:56 63710 8192000000 10904152912 11361452032 1970121440 19.386 100 27 54 1 1991908688 14415232 7372016
21:10:08 25565 8192000000 10909100864 11373932544 1977808832 19.447 100 16 32 1 1995705616 12989088 4907696
21:10:45 43150 8192000000 10925119488 11387150336 1982766800 19.487 100 14 28 0 2003142128 16601120 3774208
21:11:38 18162 8192000000 10922570208 11386888192 1988116320 19.529 100 28 55 0 2013044992 16721200 8207472
21:12:10 26218 8192000000 10926814352 11381563392 1989093280 19.537 100 28 53 1 2006625664 9354160 8178224
21:12:43 22744 8192000000 10953412016 11395584000 2002239680 19.640 100 59 118 1 2034129136 14548752 17340704
21:13:15 36254 8192000000 10935154992 11405742080 1994513568 19.579 100 27 54 1 2025740080 23257888 7968624
21:14:15 56049 8192000000 10912257376 11406077952 1951691696 19.240 98 14 28 2 1974926864 19086160 4149008
21:15:42 30353 8192000000 10890984208 11373191168 1962946528 19.329 99 9 18 0 1980003664 14673088 2384048
21:16:19 20203 8192000000 10888386864 11374489600 1956212816 19.276 99 3 6 0 1966851664 9826576 812272
21:16:47 21842 8192000000 10888817200 11350925312 1947561776 19.207 99 17 34 0 1959884208 7411440 4910992
21:17:24 43132 8192000000 10879817744 11347599360 1944170912 19.180 99 20 40 0 1959332288 9198512 5962864
21:18:15 61408 8192000000 10881007360 11357700096 1961753232 19.320 100 10 20 0 1972014544 7573920 2687392
21:19:52 54081 8192000000 10900222800 11368464384 1971214688 19.395 100 34 67 1 1994151568 13767696 9169184
21:20:53 69490 8192000000 10908595072 11393564672 1981649712 19.478 100 11 22 0 2002523008 17851088 3022208
21:22:36 52093 8192000000 10908956864 11399811072 1992702400 19.565 100 23 46 1 2015840448 16134640 7003408
21:23:35 35815 8192000000 10895122288 11395092480 1965102752 19.347 99 9 18 1 1984648720 16735760 2810208
21:24:37 103510 8192000000 10891757696 11380219904 1962841872 19.329 99 10 20 0 1973974368 8582144 2550352
21:26:26 70772 8192000000 10898319264 11373940736 1955531408 19.271 99 7 14 1 1967186512 9743776 1911328
21:27:43 48917 8192000000 10915321776 11368054784 1923335856 19.014 97 24 48 1 1942888160 12265664 7286640
21:28:39 26021 8192000000 10888025168 11352838144 1929558400 19.063 98 27 53 0 1949274464 12414512 7301552
21:29:13 76847 8192000000 10899335856 11368910848 1956017280 19.274 99 12 24 2 1971664000 12204096 3442624
21:30:38 46189 8192000000 10916261968 11386011648 1947490224 19.206 98 19 38 1 1968077472 14709952 5877296
21:31:37 44314 8192000000 10920263648 11395973120 1964096208 19.339 99 15 30 0 1988643024 20613776 3933040
21:32:28 77219 8192000000 10909139232 11363782656 1882344896 18.684 95 20 40 0 1901016832 12908976 5762960
21:33:55 29353 8192000000 10923215248 11380355072 1960331504 19.309 99 51 102 0 1993377840 18424272 14622064
21:34:33 60534 8192000000 10918641328 11382235136 1954791344 19.265 99 34 67 1 1985311200 21102384 9417472
21:35:50 40602 8192000000 10881974256 11377065984 1909896256 18.906 97 22 44 1 1939249232 23106976 6246000
21:36:40 78612 8192000000 10865058496 11325665280 1807953360 18.079 93 17 35 1 1828908560 16154656 4800544
21:38:05 33154 8192000000 10873573568 11325186048 1894030832 18.778 98 36 72 0 1914178368 10397712 9749824
21:38:45 34632 8192000000 10892273424 11341053952 1927296304 19.045 99 47 96 2 1951119808 11056608 12766896
21:39:29 63453 8192000000 10871487696 11334397952 1866567312 18.556 96 28 56 1 1886203840 12042000 7594528
21:40:38 93685 8192000000 10839652768 11301593088 1835123008 18.301 95 34 68 0 1853119744 8260432 9736304
21:42:23 44833 8192000000 10856682480 11318075392 1919466576 18.983 100 24 48 1 1936274992 10388320 6420096
21:43:20 34772 8192000000 10878280816 11313737728 1917645632 18.968 99 47 94 0 1939425232 8864480 12915120
21:44:02 8684 8192000000 10877174416 11332313088 1942510144 19.167 100 50 100 0 1967535616 10896864 14128608
21:44:17 16278 8192000000 10898986784 11345743872 1952317504 19.245 100 55 110 0 1978883808 11723408 14842896
21:44:41 40437 8192000000 10867395168 11344674816 1954025824 19.259 100 23 45 1 1968342176 8487536 5828816
21:45:28 68431 8192000000 10862231456 11345076224 1917904576 18.970 98 10 20 0 1928620384 7659856 3055952
21:47:49 53483 8192000000 10848144720 11332734976 1901177632 18.836 97 19 38 2 1917503360 10745360 5580368
21:49:42 71930 8192000000 10831090064 11309293568 1823111680 18.203 94 10 20 0 1839004432 13287712 2605040
21:51:00 47706 8192000000 10856928896 11313549312 1871807904 18.599 97 15 30 1 1883831664 8265616 3758144
21:51:56 64501 8192000000 10861725456 11342598144 1918714288 18.977 99 17 34 0 1933153456 9277312 5161856
21:53:09 43451 8192000000 10842153888 11306917888 1860967616 18.511 96 24 48 0 1876450896 8704512 6778768
21:54:01 69191 8192000000 10855590032 11319238656 1904462864 18.862 99 14 28 1 1917604336 8820016 4321456
21:55:16 42080 8192000000 10883046544 11348746240 1938482736 19.135 100 30 60 2 1957395888 10416768 8496384
21:56:39 43429 8192000000 10881022320 11344748544 1925534496 19.031 99 23 46 1 1945231216 13041760 6654960
21:57:40 95743 8192000000 10885820672 11357646848 1942373552 19.166 99 17 34 0 1958747648 11460400 4913696
21:59:22 67610 8192000000 10869065360 11337584640 1885912064 18.713 96 15 30 1 1899714592 9768960 4033568
22:00:37 86457 8192000000 10878755424 11341783040 1878749520 18.655 96 13 26 0 1893610960 11662576 3198864
22:02:09 60889 8192000000 10901852416 11381895168 1936281440 19.117 99 14 27 0 1954418560 14745600 3391520
22:03:16 38510 8192000000 10904566704 11362922496 1945696224 19.192 99 43 86 3 1968710752 10282256 12732272
22:04:05 104765 8192000000 10899304720 11373199360 1950668256 19.232 99 40 80 4 1974366640 12227296 11471088
22:06:09 75269 8192000000 10905523504 11369988096 1962198208 19.324 99 42 84 2 1983350544 8907504 12244832
22:07:40 51990 8192000000 10886578576 11374268416 1972524400 19.405 100 20 40 0 1986403728 8381584 5497744
22:08:40 82335 8192000000 10907558816 11388518400 1978943680 19.456 100 9 18 0 1989119600 7752208 2423712
22:10:15 30254 8192000000 10893490368 11378532352 1976956064 19.441 100 17 34 1 1992184496 9767360 5461072
22:11:01 42679 8192000000 10890551680 11362537472 1907270752 18.885 96 24 48 0 1927682944 12998592 7413600
22:11:54 62358 8192000000 10897744592 11375149056 1965084208 19.346 100 15 30 0 1982356688 13065648 4206832
22:13:09 66513 8192000000 10902299360 11372462080 1952380912 19.245 99 16 32 0 1972162800 14844864 4937024
22:14:45 74164 8192000000 10878357264 11368333312 1905014640 18.867 97 14 28 0 1925746576 16743696 3988240
22:16:11 44537 8192000000 10894590368 11374268416 1961167232 19.315 100 13 25 1 1979094352 14390592 3536528
22:17:08 34332 8192000000 10889533760 11366649856 1939483104 19.143 98 45 90 1 1964414816 12012976 12918736
22:18:05 42178 8192000000 10886501824 11358801920 1944495968 19.183 99 20 39 1 1957131792 7151328 5484496
22:18:54 76747 8192000000 10881970432 11350294528 1895791904 18.792 96 33 66 0 1914750288 9692128 9266256
22:20:19 32781 8192000000 10866044272 11322499072 1866400320 18.555 95 25 49 0 1881120080 8095104 6624656
22:20:59 18466 8192000000 10910448640 11351457792 1938489296 19.135 99 55 107 2 1963217888 9478560 15250032
22:21:24 31296 8192000000 10895037712 11353251840 1918609216 18.976 98 37 74 0 1940119712 11525008 9985488
22:22:01 79784 8192000000 10867833344 11331694592 1818010176 18.161 93 22 44 0 1835965888 11415184 6540528
22:23:28 71732 8192000000 10838064512 11322261504 1821404864 18.189 94 26 51 1 1839957152 10887136 7665152
22:25:16 60749 8192000000 10854878384 11331784704 1895829808 18.793 98 19 38 0 1916851856 15745152 5276896
22:26:30 64780 8192000000 9079080368 9291620352 241540128 2.864 13 1 2 0 245075920 3473664 62128

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-02-2021 22:28:18 to 13-02-2021 22:28:51.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 98 v_add_invoice_to_stock 335544517
except 5 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 13-02-2021 22:28:52 to 13-02-2021 22:28:54.

Content of mon$database and FB version

MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          243309
MON$OLDEST_ACTIVE               243310
MON$OLDEST_SNAPSHOT             243310
MON$NEXT_TRANSACTION            243310
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                       2038432
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.33415 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33415 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33415 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33415 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 ---
:336: 
:337: mscs-test-161.budzdorov.ru    Sat Feb 13 22:27:36 2021
:338:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:339: 
--- end of diff output ---

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

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