Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 26.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 17246068 kB
MemAvailable 31076456 kB
Buffers 0 kB
Cached 14431988 kB
SwapCached 3276 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-26 22:27:18
DTS_END                         2021-02-26 22:27:18.6420
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/40104
TRN_ID                          228473
ATT_ID                          628
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: 8942.67 22816 1073120
customer order: creation 162.40 358 19488
customer order: refuse 14.18 368 1702
order to supplier: creation 43.39 1288 5207
order to supplier: removal 3.23 98894 388
invoice (draft): creation 43.51 3265 5221
invoice (draft): removal 51.90 738 6228
invoice accept: apply 39.82 19950 4778
invoice accept: cancel 46.93 874 5632
customer reserve: creation 3682.02 199 441842
customer reserve: removal 4562.88 54 547546
realization accept: apply 79.15 191 9498
realization accept: cancel 88.08 114 10569
payment from customer: creation 57.01 140 6841
payment from customer: removal 5.67 92 680
payment to supplier: creation 47.40 136 5688
payment to supplier: removal 3.53 81 424
service: total inventory turnovers 4.63 1342 556
service: total monetary turnovers 6.05 27 726
service: aggregate perf. data 0.85 18556 102
service: refresh index statistics 0.03 309651 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 26-02-2021 22:28:15 to 26-02-2021 22:28:17.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3888
TEST_TIME 2 5004
TEST_TIME 3 4762
TEST_TIME 4 4507
TEST_TIME 5 4406
TEST_TIME 6 4844
TEST_TIME 7 5087
TEST_TIME 8 5161
TEST_TIME 9 5402
TEST_TIME 10 5649
TEST_TIME 11 5878
TEST_TIME 12 5897
TEST_TIME 13 6598
TEST_TIME 14 6936
TEST_TIME 15 7097
TEST_TIME 16 7495
TEST_TIME 17 8014
TEST_TIME 18 8204
TEST_TIME 19 8212
TEST_TIME 20 8645
TEST_TIME 21 8930
TEST_TIME 22 9289
TEST_TIME 23 10187
TEST_TIME 24 10338
TEST_TIME 25 9975
TEST_TIME 26 10152
TEST_TIME 27 10045
TEST_TIME 28 10013
TEST_TIME 29 9774
TEST_TIME 30 9891
TEST_TIME 31 9862
TEST_TIME 32 9768
TEST_TIME 33 9602
TEST_TIME 34 9507
TEST_TIME 35 9540
TEST_TIME 36 9338
TEST_TIME 37 9517
TEST_TIME 38 9354
TEST_TIME 39 9305
TEST_TIME 40 9345
TEST_TIME 41 9185
TEST_TIME 42 9120
TEST_TIME 43 9095
TEST_TIME 44 9202
TEST_TIME 45 9180
TEST_TIME 46 9288
TEST_TIME 47 9484
TEST_TIME 48 9506
TEST_TIME 49 9602
TEST_TIME 50 9537
TEST_TIME 51 9533
TEST_TIME 52 9420
TEST_TIME 53 9588
TEST_TIME 54 9547
TEST_TIME 55 9508
TEST_TIME 56 9381
TEST_TIME 57 9328
TEST_TIME 58 9373
TEST_TIME 59 9286
TEST_TIME 60 9250
TEST_TIME 61 9248
TEST_TIME 62 9197
TEST_TIME 63 9137
TEST_TIME 64 9101
TEST_TIME 65 9102
TEST_TIME 66 9096
TEST_TIME 67 9064
TEST_TIME 68 9107
TEST_TIME 69 9083
TEST_TIME 70 9198
TEST_TIME 71 9167
TEST_TIME 72 9322
TEST_TIME 73 9324
TEST_TIME 74 9273
TEST_TIME 75 9239
TEST_TIME 76 9253
TEST_TIME 77 9369
TEST_TIME 78 9319
TEST_TIME 79 9222
TEST_TIME 80 9176
TEST_TIME 81 9128
TEST_TIME 82 9185
TEST_TIME 83 9091
TEST_TIME 84 9090
TEST_TIME 85 9049
TEST_TIME 86 9052
TEST_TIME 87 9011
TEST_TIME 88 8989
TEST_TIME 89 8973
TEST_TIME 90 8967
TEST_TIME 91 8934
TEST_TIME 92 8941
TEST_TIME 93 8986
TEST_TIME 94 8989
TEST_TIME 95 9007
TEST_TIME 96 9103
TEST_TIME 97 9084
TEST_TIME 98 9060
TEST_TIME 99 9082
TEST_TIME 100 9122
TEST_TIME 101 9131
TEST_TIME 102 9093
TEST_TIME 103 9204
TEST_TIME 104 9183
TEST_TIME 105 9101
TEST_TIME 106 9053
TEST_TIME 107 9015
TEST_TIME 108 9036
TEST_TIME 109 8997
TEST_TIME 110 8965
TEST_TIME 111 8944
TEST_TIME 112 8910
TEST_TIME 113 8873
TEST_TIME 114 8870
TEST_TIME 115 8876
TEST_TIME 116 8871
TEST_TIME 117 8889
TEST_TIME 118 8926
TEST_TIME 119 8957
TEST_TIME 120 8945

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 26-02-2021 22:28:19 to 26-02-2021 22:28:22.

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 1482452 1482452 0 0.00 0 30911 7 0 0
doc_list_biud 1482452 1482452 0 0.00 0 55155 26 0 0
sp_add_invoice_to_stock 4868 4778 90 1.84 21 246054 19951 0 90
sp_cancel_adding_invoice 5632 5632 0 0.00 4 87760 875 0 0
sp_cancel_client_order 1702 1702 0 0.00 4 13970 368 0 0
sp_cancel_customer_reserve 547546 547546 0 0.00 1 46619 55 0 0
sp_cancel_pay_from_customer 680 680 0 0.00 3 8857 92 0 0
sp_cancel_pay_to_supplier 424 424 0 0.00 3 8286 82 0 0
sp_cancel_supplier_invoice 6237 6228 9 0.14 1 18232 738 0 9
sp_cancel_supplier_order 388 388 0 0.00 6 983470 98895 0 0
sp_cancel_write_off 10569 10569 0 0.00 1 16190 115 0 0
sp_client_order 19488 19488 0 0.00 4 17416 358 0 0
sp_customer_reserve 441842 441842 0 0.00 0 66541 199 0 0
sp_fill_shopping_cart 29912 29912 0 0.00 1 24778 42 0 0
sp_fill_shopping_cart_clo_res 441836 441836 0 0.00 0 11522 14 0 0
sp_get_clo_for_invoice 4772 4772 0 0.00 0 23540 340 0 0
sp_kill_cost_storno 17305 17305 0 0.00 0 11381 54 0 0
sp_kill_qstorno_ret_qs2qd 1112277 1112277 0 0.00 0 46612 30 0 0
sp_kill_qty_storno 586335 586335 0 0.00 0 55153 65 0 0
sp_lock_selected_doc 19882 19882 0 0.00 0 7338 5 0 0
sp_make_cost_storno 26799 26799 0 0.00 0 30908 58 0 0
sp_multiply_rows_for_pdistr 26799 26799 0 0.00 0 9632 26 0 0
sp_multiply_rows_for_qdistr 19488 19488 0 0.00 0 14537 169 0 0
sp_pay_from_customer 6841 6841 0 0.00 4 19846 140 0 0
sp_pay_to_supplier 5688 5688 0 0.00 5 30914 137 0 0
sp_payment_common 12529 12529 0 0.00 1 19580 35 0 0
sp_qd_handle_on_cancel_clo 1702 1702 0 0.00 0 9680 320 0 0
sp_qd_handle_on_invoice_upd_sts 10404 10404 0 0.00 0 55149 341 0 0
sp_qd_handle_on_reserve_upd_sts 9498 9498 0 0.00 0 10045 60 0 0
sp_reserve_write_off 9498 9498 0 0.00 6 17606 191 0 0
sp_supplier_invoice 5221 5221 0 0.00 6 81764 3266 0 0
sp_supplier_order 5207 5207 0 0.00 6 33818 1289 0 0
srv_aggregate_perf_data 102 102 0 0.00 2630 162992 18557 0 0
srv_fill_mon_cache_memory 157 157 0 0.00 1939 168526 32761 0 0
srv_find_qd_qs_mism 1027579 1027579 0 0.00 0 14906 6 0 0
srv_make_invnt_saldo 556 556 0 0.00 45 123865 1342 0 0
srv_make_money_saldo 726 726 0 0.00 1 2846 27 0 0
srv_recalc_idx_stat 4 4 0 0.00 190014 520369 309652 0 0
t$perf-abend:sp_add_invoice_to_stock 90 90 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 4778 4778 0 0.00 0 41390 210 0 0
t$perf-norm:sp_cancel_adding_invoice 393 393 0 0.00 1 10846 139 0 0
t$perf-norm:sp_cancel_client_order 1702 1702 0 0.00 0 2924 13 0 0
t$perf-norm:sp_cancel_customer_reserve 673 673 0 0.00 0 2244 12 0 0
t$perf-norm:sp_cancel_pay_from_customer 680 680 0 0.00 0 6660 13 0 0
t$perf-norm:sp_cancel_pay_to_supplier 424 424 0 0.00 0 1987 7 0 0
t$perf-norm:sp_cancel_supplier_invoice 380 380 0 0.00 0 710 11 0 0
t$perf-norm:sp_cancel_supplier_order 388 388 0 0.00 0 29813 1718 0 0
t$perf-norm:sp_cancel_write_off 972 972 0 0.00 0 2326 9 0 0
t$perf-norm:sp_client_order 19488 19488 0 0.00 0 19831 20 0 0
t$perf-norm:sp_customer_reserve 932 932 0 0.00 0 4380 9 0 0
t$perf-norm:sp_pay_from_customer 6841 6841 0 0.00 0 17325 13 0 0
t$perf-norm:sp_pay_to_supplier 5688 5688 0 0.00 0 7915 15 0 0
t$perf-norm:sp_reserve_write_off 9498 9498 0 0.00 0 9235 17 0 0
t$perf-norm:sp_supplier_invoice 5221 5221 0 0.00 0 15437 20 0 0
t$perf-norm:sp_supplier_order 5207 5207 0 0.00 0 7158 19 0 0
t$perf-norm:srv_aggregate_perf_data 102 102 0 0.00 0 703 13 0 0
t$perf-norm:srv_fill_mon_cache_memory 157 157 0 0.00 0 4354 34 0 0
t$perf-norm:srv_make_invnt_saldo 556 556 0 0.00 0 6959 42 0 0
t$perf-norm:srv_make_money_saldo 726 726 0 0.00 0 1444 14 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 12 5 0 0
v_add_invoice_to_stock 9724 9544 180 1.85 0 15896 27 0 180
v_all_customers 35680 35680 0 0.00 0 19 1 0 0
v_all_suppliers 29166 29166 0 0.00 0 29 1 0 0
v_all_wares 38976 38976 0 0.00 0 50 1 0 0
v_cancel_adding_invoice 786 786 0 0.00 0 7720 21 0 0
v_cancel_client_order 3404 3404 0 0.00 0 12800 18 0 0
v_cancel_customer_prepayment 1360 1360 0 0.00 0 8796 17 0 0
v_cancel_customer_reserve 1346 1346 0 0.00 0 3785 8 0 0
v_cancel_payment_to_supplier 848 848 0 0.00 0 8267 17 0 0
v_cancel_supplier_invoice 778 760 18 2.31 0 1438 17 0 18
v_cancel_supplier_order 776 776 0 0.00 0 584 5 0 0
v_cancel_write_off 1944 1944 0 0.00 0 3886 14 0 0
v_max_id_clo_ord 5207 5207 0 0.00 0 879 1 0 0
v_max_id_clo_res 932 932 0 0.00 0 6351 19 0 0
v_max_id_ord_sup 5217 5217 0 0.00 0 5400 4 0 0
v_max_non_paid_invoice 1529 1529 0 0.00 0 552 2 0 0
v_max_non_paid_realizn 3519 3519 0 0.00 0 6506 7 0 0
v_min_id_clo_ord 5207 5207 0 0.00 0 3027 7 0 0
v_min_id_clo_res 932 932 0 0.00 0 2729 10 0 0
v_min_id_ord_sup 5217 5217 0 0.00 0 10431 10 0 0
v_min_non_paid_invoice 5688 5688 0 0.00 0 7654 22 0 0
v_min_non_paid_realizn 6841 6841 0 0.00 0 19573 20 0 0
v_our_firm 9940 9940 0 0.00 0 41 1 0 0
v_reserve_write_off 18996 18996 0 0.00 0 16342 14 0 0
x_lock_depdocs_on_canc_invoice 11480 11480 0 0.00 0 28424 125 0 0
x_lock_depdocs_on_canc_sup_ord 388 388 0 0.00 0 8612 382 0 0
x_make_qstorno_1000_1200 5207 5207 0 0.00 1 33804 1206 0 0
x_make_qstorno_1200_2000 5221 5221 0 0.00 3 74732 3117 0 0
x_make_qstorno_2100_3300 441842 441842 0 0.00 0 61366 182 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 26-02-2021 22:28:23 to 26-02-2021 22:28:27.

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:22 9 8192000000 8804091152 8816721920 7620560 0.092 3 1 2 0 7741264 58144 62560
19:57:29 12878 8192000000 10227436992 10531799040 1017863264 11.051 80 65 130 1 1042139200 2870816 21405120
19:57:49 19144 8192000000 10319334384 10627837952 1350152928 14.149 100 83 165 0 1382458000 4522800 27782272
19:58:19 24811 8192000000 10355260720 10672062464 1401205440 14.606 100 84 168 0 1435732320 6181696 28345184
19:58:54 36184 8192000000 10402827344 10726535168 1444430240 14.989 100 91 182 0 1481190640 6918496 29841904
19:59:40 25110 8192000000 10426969872 10756382720 1473980528 15.249 100 87 171 1 1509404448 7827024 27596896
20:00:20 16741 8192000000 10441885008 10773725184 1493876992 15.423 100 94 188 0 1532303136 8443808 29982336
20:00:48 15049 8192000000 10448704192 10786930688 1503549808 15.507 100 86 172 0 1540327664 9094112 27683744
20:01:15 23783 8192000000 10496018272 10837340160 1531821152 15.753 100 83 166 0 1566878752 8870432 26187168
20:01:46 9508 8192000000 10506097408 10854539264 1559670288 15.993 100 78 156 0 1593032544 9321760 24040496
20:02:14 15031 8192000000 10539777648 10892820480 1600074848 16.340 100 80 160 1 1634619376 10448800 24095728
20:02:36 5071 8192000000 10549641360 10906464256 1616469344 16.480 100 82 164 0 1651876688 10960960 24446384
20:02:50 7820 8192000000 10571794560 10926100480 1630907248 16.603 100 85 169 2 1667929328 11486400 25535680
20:03:09 10769 8192000000 10598711456 10960183296 1654671664 16.804 100 79 158 2 1690448672 12329808 23447200
20:03:31 11570 8192000000 10613698544 10978533376 1669494224 16.929 100 79 158 0 1705247504 12230000 23523280
20:03:52 9181 8192000000 10629128464 10992001024 1683863040 17.050 100 82 163 2 1720837936 12485232 24489664
20:04:09 11240 8192000000 10645532960 11015512064 1703933104 17.218 100 88 176 1 1742075312 13074768 25067440
20:04:28 8907 8192000000 10653660288 11022655488 1712865440 17.293 100 81 162 0 1748287504 11542608 23879456
20:04:44 7241 8192000000 10663051328 11041320960 1726570512 17.407 100 76 151 0 1760568896 11635248 22363136
20:04:59 4575 8192000000 10679926496 11055874048 1741343440 17.530 100 75 149 0 1774429536 11441904 21644192
20:05:11 5069 8192000000 10691162976 11069616128 1753450688 17.630 100 78 156 0 1787744928 12276800 22017440
20:05:23 4909 8192000000 10706579600 11087073280 1768238464 17.752 100 81 161 1 1803152752 12386672 22527616
20:05:36 5648 8192000000 10722201136 11099148288 1782400384 17.869 100 84 169 0 1818746896 12954704 23391808
20:05:50 4781 8192000000 10731350656 11108917248 1787599792 17.912 100 84 168 3 1824652256 13440560 23611904
20:06:02 3944 8192000000 10733242000 11111899136 1794851936 17.972 100 94 187 3 1835913920 14003872 27058112
20:06:13 4252 8192000000 10740561168 11123519488 1798288960 18.000 100 81 162 1 1834727872 13230672 23208240
20:06:24 2473 8192000000 10749764608 11130646528 1810575056 18.101 100 87 173 1 1847398672 12712176 24111440
20:06:33 2750 8192000000 10748141040 11129442304 1814591888 18.133 100 91 184 2 1852727584 12871424 25264272
20:06:43 2439 8192000000 10749722624 11137953792 1810235712 18.098 100 77 154 2 1844950272 13166256 21548304
20:06:53 6298 8192000000 10748917520 11138269184 1814100592 18.129 100 76 148 2 1847870720 13086912 20683216
20:07:05 4751 8192000000 10769677248 11155972096 1822589152 18.199 100 81 162 0 1859917008 14157584 23170272
20:07:17 3649 8192000000 10766177888 11149611008 1834235840 18.294 100 75 150 1 1868438560 13464272 20738448
20:07:27 2298 8192000000 10791304176 11173752832 1839934912 18.340 100 88 175 3 1880109728 14870864 25303952
20:07:36 1984 8192000000 10793897920 11179917312 1848838288 18.413 100 84 168 0 1886035776 13949152 23248336
20:07:44 2327 8192000000 10803876096 11189886976 1855894960 18.470 100 96 192 1 1897264848 14115488 27254400
20:07:53 2121 8192000000 10802913152 11191779328 1859052096 18.496 100 95 190 5 1899475536 14404016 26019424
20:08:01 1679 8192000000 10808417056 11195879424 1863617744 18.533 100 93 186 1 1903999728 14642352 25739632
20:08:09 2973 8192000000 10810235184 11196727296 1864559008 18.540 100 86 168 1 1901721408 13132928 24029472
20:08:19 2205 8192000000 10814340304 11200307200 1863879680 18.535 100 91 183 0 1902926064 13477104 25569280
20:08:27 1546 8192000000 10810254096 11198578688 1869399056 18.579 100 92 182 2 1909611648 13724976 26487616
20:08:35 2484 8192000000 10822923072 11209699328 1874013552 18.617 100 91 182 0 1913038992 13838128 25187312
20:08:44 1959 8192000000 10813928512 11206488064 1872989296 18.608 100 78 154 0 1908360112 14255440 21115376
20:08:52 15882 8192000000 10798968192 11202220032 1871269984 18.595 100 59 113 2 1896608080 8413632 16924464
20:09:14 10924 8192000000 10826522400 11216400384 1880813808 18.672 100 96 193 0 1919611072 10821024 27976240
20:09:31 3571 8192000000 10808836640 11211784192 1878682160 18.654 100 65 130 0 1909020336 11007424 19330752
20:09:42 2830 8192000000 10814915152 11215749120 1880801840 18.672 100 65 130 1 1912186048 12965568 18418640
20:09:51 1841 8192000000 10814056688 11221979136 1884550096 18.702 100 72 146 0 1916116080 11530480 20035504
20:09:59 6594 8192000000 10790005440 11210092544 1876556544 18.637 100 35 68 0 1893904320 7809920 9537856
20:10:15 4075 8192000000 10808919824 11220856832 1884822224 18.704 100 47 94 3 1904195408 6129072 13244112
20:10:27 4479 8192000000 10799992128 11223666688 1883133968 18.690 100 40 80 1 1907165648 13312752 10718928
20:10:38 53407 8192000000 10803126880 11222151168 1883106928 18.690 100 34 69 0 1899263136 5753120 10403088
20:11:38 16512 8192000000 10803200032 11228921856 1883880192 18.696 100 27 53 0 1897047184 6302384 6864608
20:12:00 6877 8192000000 10808303440 11233013760 1887938544 18.729 100 26 49 2 1903206448 7737856 7530048
20:12:14 8899 8192000000 10797475840 11230789632 1889753136 18.744 100 26 51 3 1904025088 6476704 7795248
20:12:29 5460 8192000000 10799908976 11233652736 1891148496 18.755 100 27 54 1 1905346960 6706592 7491872
20:12:41 7412 8192000000 10794265792 11232354304 1892486192 18.766 100 20 39 4 1903579280 5736880 5356208
20:12:55 5699 8192000000 10809695312 11238346752 1894212592 18.780 100 29 54 3 1907665888 4903936 8549360
20:13:07 4169 8192000000 10821282672 11244576768 1898494336 18.814 100 33 65 1 1918536896 9957648 10084912
20:13:18 6927 8192000000 10810859168 11240132608 1897573808 18.807 100 28 56 2 1911898272 6135024 8189440
20:13:31 7964 8192000000 10815449552 11244650496 1898932224 18.818 100 14 29 0 1908059696 4614896 4512576
20:13:46 12823 8192000000 10803562688 11244134400 1900852304 18.833 100 17 34 1 1911604064 6049296 4702464
20:14:04 7990 8192000000 10809700160 11246886912 1903147520 18.852 100 23 46 1 1915394816 5449248 6798048
20:14:19 12034 8192000000 10806946944 11245965312 1904541312 18.863 100 22 43 1 1916699536 5791328 6366896
20:14:39 8523 8192000000 10823071264 11253604352 1908634256 18.896 100 23 46 1 1920983600 5897328 6452016
20:14:55 8939 8192000000 10815889392 11248668672 1891635856 18.759 99 28 56 0 1905623024 6039952 7947216
20:15:14 16714 8192000000 10827147424 11256131584 1908488016 18.895 100 27 54 1 1921675376 5615200 7572160
20:15:37 58792 8192000000 10822570608 11255562240 1892357056 18.765 99 38 74 0 1908141600 4645584 11138960
20:16:42 10881 8192000000 10821042176 11262709760 1912284960 18.925 100 21 42 0 1924288176 6414224 5588992
20:16:59 4444 8192000000 10828992480 11255902208 1890719504 18.752 99 34 68 0 1906715536 6220016 9776016
20:17:11 5490 8192000000 10821936976 11250622464 1885496256 18.709 99 33 66 1 1902755280 8269520 8989504
20:17:24 5087 8192000000 10823369984 11253137408 1905821472 18.873 100 24 48 1 1918627152 5962880 6842800
20:17:37 4607 8192000000 10814143152 11246047232 1898990784 18.818 100 24 48 1 1911701072 5656768 7053520
20:17:48 5654 8192000000 10826334112 11258200064 1906418464 18.878 100 25 50 2 1919353856 5023584 7911808
20:18:02 6747 8192000000 10806603648 11235151872 1877603664 18.646 99 31 62 3 1893740080 7409456 8726960
20:18:15 8628 8192000000 10792420688 11223547904 1837859760 18.323 97 31 62 2 1853825088 7093008 8872320
20:18:31 7878 8192000000 10750589824 11184869376 1834393984 18.295 98 19 36 0 1844995040 5564384 5036672
20:18:46 7149 8192000000 10795796688 11211743232 1840515792 18.345 98 20 38 2 1852648368 5134352 6998224
20:19:03 5085 8192000000 10742520512 11163987968 1786556288 17.903 97 17 34 0 1797140848 5387232 5197328
20:19:17 7812 8192000000 10722145568 11143614464 1798039088 17.998 98 17 33 2 1807952656 5246272 4667296
20:19:31 10630 8192000000 10747988512 11170287616 1811915680 18.112 99 20 38 2 1823034368 6031232 5087456
20:19:47 13814 8192000000 10715763968 11133042688 1685796560 17.066 92 20 38 1 1695875920 4936592 5142768
20:20:08 50532 8192000000 10696076000 11104776192 1686452528 17.072 93 35 71 1 1701699008 5957968 9288512
20:21:05 15396 8192000000 10758022448 11145945088 1813116624 18.121 100 81 164 0 1843205024 7110240 22978160
20:21:26 7350 8192000000 10720214960 11143946240 1803447520 18.042 100 29 59 2 1818160720 6623488 8089712
20:21:41 8023 8192000000 10708818464 11125809152 1728994400 17.427 95 29 57 3 1742079616 5792832 7292384
20:21:55 7065 8192000000 10728039360 11141533696 1797766224 17.996 99 48 94 1 1817718336 7103520 12848592
20:22:08 4952 8192000000 10697807920 11111489536 1752269440 17.620 97 28 56 2 1765808768 5350480 8188848
20:22:20 9185 8192000000 10747916288 11157659648 1798329920 18.000 99 31 62 0 1814411792 7066160 9015712
20:22:37 9043 8192000000 10717274240 11138146304 1767941216 17.750 98 19 38 2 1779033040 5347728 5744096
20:22:53 8094 8192000000 10710461680 11130216448 1780637616 17.855 99 20 40 1 1791298640 5057504 5603520
20:23:08 7064 8192000000 10727574016 11142496256 1808071168 18.080 100 29 55 2 1821359440 5278976 8009296
20:23:24 5751 8192000000 10738838512 11156250624 1804169360 18.048 99 34 68 4 1820051728 5852368 10030000
20:23:43 8070 8192000000 10731067808 11167236096 1832185872 18.277 100 32 64 2 1847484944 5637760 9661312
20:24:03 9610 8192000000 10746423360 11166617600 1815331088 18.140 99 29 59 0 1829055760 5088848 8635824
20:24:19 6381 8192000000 10754378528 11178254336 1837583488 18.321 100 26 51 1 1851564480 5837264 8143728
20:24:37 13475 8192000000 10769853424 11189137408 1845009024 18.382 100 24 48 1 1857602208 5682800 6910384
20:24:58 63388 8192000000 10763335936 11197440000 1853105952 18.447 100 30 60 0 1867987408 5772880 9108576
20:26:10 10494 8192000000 10767599376 11196940288 1855996160 18.471 100 24 48 1 1868639856 5845696 6798000
20:26:27 4479 8192000000 10769924352 11200790528 1857223792 18.481 100 25 50 2 1871784976 7176480 7384704
20:26:39 8157 8192000000 10786346240 11202187264 1862285072 18.522 100 27 54 1 1876103616 6553376 7265168
20:26:54 5851 8192000000 10776999120 11208937472 1864158304 18.537 100 34 68 1 1880763888 6913088 9692496
20:27:08 8838 8192000000 10800454368 11228090368 1883965120 18.697 100 34 65 2 1899520496 6039648 9515728
20:27:25 13311 8192000000 10825082048 11244445696 1897366544 18.805 100 42 81 3 1914145120 4512816 12265760
20:27:46 18614 8192000000 10833794272 11255652352 1908011856 18.891 100 38 76 0 1925428352 6685680 10730816
20:28:25 22144 8192000000 10850452656 11272278016 1919131632 18.980 100 46 88 3 1942189616 10250320 12807664
20:28:59 30530 8192000000 10862669408 11285807104 1927553360 19.047 100 46 92 1 1955658432 14295872 13809200
20:30:06 10640 8192000000 10880686720 11304820736 1937012160 19.123 100 40 79 2 1960469968 12605280 10852528
20:30:26 12027 8192000000 10884310848 11309064192 1944111088 19.180 100 48 96 2 1971329312 13478352 13739872
20:30:54 20030 8192000000 10881421120 11312082944 1946754576 19.201 100 40 80 1 1972020432 13781120 11484736
20:31:24 4774 8192000000 10896447104 11321847808 1954266256 19.260 100 57 112 3 1984696560 15065136 15365168
20:31:39 51792 8192000000 10890529184 11329773568 1957643904 19.287 100 49 98 0 1988103104 16421696 14037504
20:32:56 27017 8192000000 10895665168 11333861376 1960827504 19.313 100 31 62 0 1987194688 16970432 9396752
20:33:37 13228 8192000000 10912439568 11346817024 1973017616 19.409 100 45 90 0 2003393072 16134768 14240688
20:33:58 9621 8192000000 10929815568 11356594176 1984496752 19.500 100 68 135 0 2021085520 17240320 19348448
20:34:14 5867 8192000000 10929136816 11358838784 1984456208 19.500 100 60 121 0 2020222944 17951936 17814800
20:34:27 5528 8192000000 10932598208 11359870976 1987574512 19.525 100 67 130 1 2024013392 17791792 18647088
20:34:40 2782 8192000000 10948411808 11365801984 1992643376 19.565 100 72 144 1 2031808608 17794432 21370800
20:34:49 26539 8192000000 10936375392 11367510016 1993256752 19.570 100 63 126 1 2030464112 19423328 17784032
20:35:32 2024 8192000000 10959425120 11381321728 1997332304 19.602 100 65 130 0 2037447696 21423520 18691872
20:35:40 5344 8192000000 10952413296 11379838976 2002220496 19.640 100 76 152 2 2045780928 22228816 21331616
20:36:06 4376 8192000000 10971234304 11393720320 2007218560 19.680 100 64 128 1 2049809952 24013392 18578000
20:36:19 4659 8192000000 10973097328 11394748416 2012466656 19.721 100 76 148 2 2058155056 23944512 21743888
20:36:31 3824 8192000000 10976492736 11401859072 2014253952 19.735 100 81 162 0 2063448128 25797328 23396848
20:36:42 7622 8192000000 10974409520 11402776576 2011753904 19.715 100 65 129 1 2056628688 26155984 18718800
20:36:58 3911 8192000000 10967884368 11399888896 2015480592 19.745 100 69 136 0 2060117936 24349296 20288048
20:37:08 3326 8192000000 10976707952 11404480512 2019633776 19.777 100 77 154 2 2068089328 24546352 23909200
20:37:18 5780 8192000000 10981656000 11413491712 2015603440 19.746 100 62 123 1 2057676832 23891968 18181424
20:37:30 10906 8192000000 10968121728 11400683520 2010875488 19.708 100 65 129 0 2055440864 25757360 18808016
20:37:52 7210 8192000000 10983662416 11412156416 2020970256 19.788 100 67 132 1 2070109280 28406288 20732736
20:38:11 1939 8192000000 10979806112 11410059264 2016312608 19.751 100 71 142 1 2066328944 28760208 21256128
20:38:20 5119 8192000000 10981856608 11410030592 2018962496 19.772 100 66 132 1 2067710400 28948944 19798960
20:38:33 3180 8192000000 10993238672 11418816512 2022092880 19.797 100 69 135 2 2073107328 30389504 20624944
20:38:43 8392 8192000000 10976629168 11396841472 1986213472 19.514 98 72 141 2 2043971696 36605200 21153024
20:39:02 3891 8192000000 10969471968 11393732608 1998416144 19.610 100 80 160 2 2058582928 35265328 24901456
20:39:17 3154 8192000000 10968012752 11389452288 1994968928 19.583 100 67 133 0 2050579744 35483648 20127168
20:39:29 6671 8192000000 10973583632 11398635520 1998136320 19.608 100 69 137 2 2056007808 36340112 21531376
20:39:46 5384 8192000000 10976603200 11404259328 2003291296 19.649 100 71 143 0 2063877552 38386544 22199712
20:40:00 7493 8192000000 10981283072 11413192704 2006318768 19.673 100 68 136 0 2069505216 41556656 21629792
20:40:23 4954 8192000000 10992801840 11422056448 2017414368 19.760 100 66 130 2 2076963008 39329168 20219472
20:40:36 4983 8192000000 10986222848 11417481216 2019016352 19.772 100 63 126 1 2072912720 34165904 19730464
20:40:49 4898 8192000000 10981826064 11414413312 2013954240 19.733 100 66 129 1 2068301520 34079920 20267360
20:41:07 2750 8192000000 10983672048 11411980288 2012190304 19.719 100 80 159 1 2072908688 36192272 24526112
20:41:19 4944 8192000000 10979780656 11404431360 1989067504 19.536 99 69 134 0 2050614880 40495072 21052304
20:41:32 8070 8192000000 10993036256 11416907776 2011872192 19.716 100 80 161 0 2076133632 39668880 24592560
20:41:54 5293 8192000000 10992263184 11416788992 2007131648 19.679 100 81 160 0 2075210656 43477104 24601904
20:42:11 3507 8192000000 10980826160 11415191552 2009123104 19.695 100 58 116 0 2066820768 39389504 18308160
20:42:21 5958 8192000000 10978643856 11416834048 1993992848 19.575 99 57 113 1 2051467264 39398544 18075872
20:42:34 5425 8192000000 10998761808 11425292288 2015440336 19.744 100 75 150 0 2080343776 41063152 23840288
20:42:47 4957 8192000000 10964497104 11389997056 1965900176 19.353 98 69 137 2 2028343808 41057792 21385840
20:42:59 6393 8192000000 10977737760 11405656064 1995784592 19.589 100 69 138 2 2060083504 42087936 22210976
20:43:12 2716 8192000000 10976133568 11402207232 1995373424 19.586 100 69 137 1 2057550784 39645424 22531936
20:43:23 1956 8192000000 10992629600 11414802432 2005983648 19.670 100 78 155 2 2070739520 40779584 23976288
20:43:32 2042 8192000000 10985002624 11406622720 1999585456 19.619 100 66 132 0 2060005248 39005296 21414496
20:43:42 5827 8192000000 10962481216 11391942656 1972170272 19.403 99 68 136 3 2034519456 40586336 21762848
20:43:54 4356 8192000000 10956144288 11378589696 1976872320 19.440 100 76 151 3 2042046624 40921008 24253296
20:44:07 3593 8192000000 10968047808 11389505536 1984302672 19.499 100 79 157 0 2051918304 42937952 24677680
20:44:21 3714 8192000000 10963489632 11391631360 1987305184 19.522 100 71 141 3 2050101232 40455648 22340400
20:44:32 7553 8192000000 10959221888 11396149248 1992788944 19.566 100 78 154 1 2058708432 41799168 24120320
20:44:49 3757 8192000000 10958393360 11383549952 1968940192 19.377 99 80 160 0 2026519536 33329184 24250160
20:45:02 5618 8192000000 10986007568 11399917568 1995658640 19.588 100 90 181 2 2058204256 35724368 26821248
20:45:15 2044 8192000000 10984939040 11403603968 1999395136 19.618 100 89 178 1 2064559808 37533536 27631136
20:45:23 14271 8192000000 10957578704 11403608064 1993102384 19.568 100 51 100 1 2046175168 36973264 16099520
20:46:00 18691 8192000000 10936170416 11390386176 1979695952 19.462 100 31 62 2 2024926272 34645392 10584928
20:46:28 17860 8192000000 10918812256 11369697280 1921515728 18.999 97 33 66 0 1967347312 34895680 10935904
20:46:57 20075 8192000000 10915508032 11361091584 1928731216 19.057 98 39 78 1 1981045984 39248112 13066656
20:47:48 16443 8192000000 10908671888 11358339072 1937768064 19.129 99 36 72 0 1984889088 35031392 12089632
20:48:10 30535 8192000000 10915135056 11363344384 1947464704 19.206 100 28 56 0 1994168656 37418528 9285424
20:48:50 25913 8192000000 10915300336 11365412864 1928132480 19.052 99 24 48 2 1975191360 38232976 8825904
20:49:27 24509 8192000000 10899991968 11343323136 1932152048 19.084 100 23 46 2 1979880928 39071344 8657536
20:49:59 10374 8192000000 10880800032 11322597376 1898639776 18.815 98 31 60 1 1947784144 39479040 9665328
20:50:15 10976 8192000000 10900259888 11344515072 1934366992 19.102 100 32 66 0 1985946528 41035088 10544448
20:50:35 21316 8192000000 10865581744 11321647104 1885822784 18.712 98 20 40 0 1920989472 28547872 6618816
20:51:07 42226 8192000000 10844777728 11299708928 1877670112 18.646 98 18 36 5 1895370704 13080000 4620592
20:51:56 54643 8192000000 10857624544 11301789696 1894778288 18.784 99 25 50 0 1918991232 17358416 6854528
20:53:14 40511 8192000000 10868832416 11307438080 1894116288 18.779 98 38 75 1 1914758288 10916624 9725376
20:54:24 82792 8192000000 10850110912 11308523520 1881590112 18.678 97 33 66 0 1905108912 14354144 9164656
20:55:54 58981 8192000000 10820964000 11267162112 1823871824 18.209 95 22 45 1 1842879024 12899744 6107456
20:56:59 96792 8192000000 10836529248 11303682048 1840714240 18.347 96 14 27 0 1853058816 8878304 3466272
20:58:42 58731 8192000000 10874467920 11332337664 1932568304 19.087 100 22 42 2 1948644976 10527200 5549472
20:59:47 39623 8192000000 10872353440 11326099456 1931985552 19.083 99 23 46 0 1951606144 12643888 6976704
21:00:38 21936 8192000000 10873879360 11324157952 1912981680 18.931 98 21 42 1 1931684160 12767888 5934592
21:01:06 168525 8192000000 10845375488 11291385856 1887152640 18.723 97 30 60 0 1920038784 24094256 8791888
21:04:01 16283 8192000000 10857238944 11311611904 1926490912 19.039 100 27 54 1 1952591040 18508368 7591760
21:04:32 32574 8192000000 10839646928 11298770944 1899529104 18.823 98 17 33 1 1917083904 12695120 4859680
21:05:12 42654 8192000000 10864628496 11318341632 1919646128 18.984 99 18 34 2 1934219632 9607680 4965824
21:06:15 83236 8192000000 10882524176 11352375296 1943721712 19.176 100 14 28 0 1962832624 14886992 4223920
21:07:55 55267 8192000000 10880008768 11356295168 1938398672 19.134 99 7 14 0 1957692512 17530960 1762880
21:09:01 31341 8192000000 10898883136 11360686080 1964300864 19.340 100 27 55 0 1991801856 19770944 7730048
21:09:38 58186 8192000000 10916063520 11375906816 1947849760 19.209 99 16 32 4 1972807408 20342096 4615552
21:10:43 39876 8192000000 10901278480 11376746496 1945015440 19.187 99 20 40 0 1978122848 27141152 5966256
21:11:39 60670 8192000000 10901718784 11364134912 1931123264 19.076 98 18 34 2 1957418752 21234736 5060752
21:12:52 67866 8192000000 10911651200 11387289600 1962807872 19.328 100 8 16 0 1985526720 20382480 2336368
21:14:12 62600 8192000000 10915649344 11386732544 1952014768 19.243 99 9 18 0 1976931696 22401168 2515760
21:15:29 33965 8192000000 10908096432 11379965952 1979927968 19.464 100 30 60 0 2007791840 19013456 8850416
21:16:17 55555 8192000000 10901803376 11375824896 1962405616 19.325 99 18 36 1 1979811904 12425504 4980784
21:17:20 38765 8192000000 10919570768 11368734720 1967775040 19.368 99 36 73 0 1986909536 9158656 9975840
21:18:07 43380 8192000000 10921327680 11386572800 1990309376 19.546 100 24 48 2 2005695952 8757584 6628992
21:18:58 34744 8192000000 10946973376 11390095360 1979174576 19.458 99 39 78 0 2000826512 10608112 11043824
21:19:39 31568 8192000000 10954667776 11405209600 1986964608 19.520 99 44 87 1 2016588688 17103536 12520544
21:20:20 61356 8192000000 10931352192 11411214336 1992802496 19.566 100 15 30 0 2015651936 18281520 4567920
21:21:27 48941 8192000000 10932154976 11385614336 1965729536 19.352 98 27 54 1 1983216832 9966432 7520864
21:22:28 57415 8192000000 10920636656 11387719680 1963531984 19.334 98 31 61 2 1984649936 12307968 8809984
21:24:08 99763 8192000000 10897139056 11364741120 1941145408 19.156 97 23 46 0 1961878032 13852992 6879632
21:25:54 35472 8192000000 10920189520 11386908672 1987432144 19.523 100 22 44 1 2002234800 8575200 6227456
21:26:36 13905 8192000000 10922695520 11388567552 1995495584 19.587 100 30 60 1 2013220512 9371328 8353600
21:27:31 34774 8192000000 10895971536 11369459712 1974899296 19.424 99 26 52 0 1992433712 10270368 7264048
21:28:14 29635 8192000000 10895092112 11376164864 1953853856 19.257 98 8 16 0 1962911680 7030848 2026976
21:28:51 30868 8192000000 10908872336 11388588032 1990559712 19.548 100 11 22 0 2001394992 7955536 2879744
21:31:07 59467 8192000000 10936641728 11417513984 2007892224 19.685 100 16 32 1 2020783984 8251712 4640048
21:32:13 38967 8192000000 10953572816 11423481856 2000928592 19.630 99 29 59 2 2019038480 9762544 8347344
21:33:13 30475 8192000000 10921847760 11388231680 1916991680 18.963 95 17 34 1 1935214752 13200416 5022656
21:33:58 71693 8192000000 10924798480 11388456960 1935416704 19.110 97 18 36 1 1955540336 14916656 5206976
21:35:16 71771 8192000000 10903477040 11383099392 1920530640 18.991 96 15 28 0 1942121792 16702832 4888320
21:36:43 40076 8192000000 10908755088 11371626496 1923496576 19.015 97 19 37 0 1949505872 20285024 5724272
21:37:32 39130 8192000000 10882141120 11350802432 1915959296 18.954 97 23 46 0 1938053856 15527760 6566800
21:38:30 112793 8192000000 10829771424 11294175232 1704788048 17.225 87 15 30 0 1726004720 17185024 4031648
21:40:29 32009 8192000000 10853399440 11314380800 1920681424 18.992 100 28 57 2 1937880112 9064016 8134672
21:41:08 32152 8192000000 10869605776 11317235712 1907134928 18.884 99 37 75 0 1928048912 10333392 10580592
21:41:53 19969 8192000000 10869633936 11310641152 1906577088 18.879 99 45 90 2 1931065904 12542656 11946160
21:42:20 38963 8192000000 10861839824 11299979264 1866438512 18.555 97 41 82 1 1892005504 14231232 11335760
21:43:05 25734 8192000000 10874023984 11322908672 1925855808 19.034 100 39 78 1 1950236704 13882976 10497920
21:43:38 17273 8192000000 10881858304 11322638336 1921451264 18.998 100 43 86 0 1954512352 21046928 12014160
21:44:09 63222 8192000000 10849728304 11322564608 1865310992 18.546 97 23 46 1 1887754480 16299200 6144288
21:45:25 72255 8192000000 10832228592 11291791360 1891302080 18.756 99 15 30 1 1908379584 12956768 4120736
21:46:48 53879 8192000000 10822908688 11280285696 1874820416 18.623 98 31 62 2 1896633216 12338864 9473936
21:47:50 23720 8192000000 10844724448 11302592512 1907287008 18.885 100 23 46 0 1928422368 14354720 6780640
21:48:20 18625 8192000000 10846397984 11304628224 1913084480 18.931 100 29 58 2 1936606320 15112832 8409008
21:48:46 43833 8192000000 10823106928 11292577792 1849696672 18.420 97 22 44 1 1873328192 16575312 7056208
21:50:59 41462 8192000000 10811949232 11289649152 1880940400 18.673 99 9 18 2 1898081200 14459808 2680992
21:51:50 47526 8192000000 10843174912 11307036672 1917138768 18.964 100 20 40 1 1931237520 7949840 6148912
21:52:47 107430 8192000000 10833701728 11308781568 1883540944 18.694 98 20 40 2 1900641280 11298800 5801536
21:54:50 61153 8192000000 10829255248 11313111040 1878500448 18.653 98 9 18 1 1893672320 12574928 2596944
21:56:19 74249 8192000000 10830098576 11306328064 1848204032 18.408 97 5 10 0 1867603488 17953904 1445552
21:57:40 65612 8192000000 10832896944 11301330944 1876122864 18.634 98 16 30 2 1892151792 11821168 4207760
21:58:52 35829 8192000000 10845082944 11306266624 1910984112 18.915 99 20 40 0 1924039984 7768880 5286992
21:59:35 70702 8192000000 10868077632 11342573568 1898523744 18.814 98 28 56 2 1917163408 11166960 7472704
22:00:55 55389 8192000000 10884885616 11341754368 1949721376 19.224 100 29 58 1 1973384208 15873232 7789600
22:01:57 57585 8192000000 10899267536 11354935296 1934680432 19.104 99 18 36 1 1952430720 12869504 4880784
22:03:01 45028 8192000000 10869241376 11357011968 1916558064 18.959 98 21 42 1 1940920912 18448288 5914560
22:04:14 22298 8192000000 10898970496 11353878528 1958807024 19.297 100 36 72 0 1977394608 7416528 11171056
22:04:48 58446 8192000000 10911799840 11370123264 1946366160 19.198 99 35 70 0 1967464432 11423584 9674688
22:06:00 49543 8192000000 10901417008 11353014272 1927481072 19.047 98 28 56 0 1949681136 14709520 7490544
22:07:01 19915 8192000000 10909501568 11358040064 1948853376 19.217 99 46 90 1 1971984096 10761792 12368928
22:07:32 12171 8192000000 10920784624 11376062464 1970574272 19.390 100 44 88 1 1997396784 14549008 12273504
22:07:52 48098 8192000000 10903341824 11366666240 1913710640 18.936 97 30 60 2 1934815248 13130496 7974112
22:08:50 49529 8192000000 10927292960 11375833088 1969811136 19.384 100 44 87 0 1992311440 10913152 11587152
22:09:58 140709 8192000000 10898141344 11384627200 1957516016 19.286 99 11 22 0 1973909248 13546400 2846832
22:13:26 80105 8192000000 10906150704 11381510144 1953909248 19.258 98 30 60 0 1971923344 10258656 7755440
22:14:57 37934 8192000000 10883010400 11372859392 1960024880 19.306 99 11 22 0 1975580000 12069200 3485920
22:15:43 3517 8192000000 10889516080 11377315840 1972919952 19.409 100 3 6 0 1981820976 8296912 604112
22:16:08 57448 8192000000 10899857856 11379560448 1985710016 19.510 100 15 30 0 1997800528 8103840 3986672
22:17:12 55211 8192000000 10898934160 11382337536 1983133680 19.490 100 9 18 1 1993590432 8066272 2390480
22:18:14 12655 8192000000 10915300128 11388715008 1988535024 19.532 100 19 38 1 2001964080 7937616 5491440
22:19:19 37031 8192000000 10928032016 11407319040 1979495024 19.461 99 27 54 2 1999514112 12011728 8007360
22:20:46 68428 8192000000 10928018944 11403583488 1964658512 19.343 98 13 26 0 1977862032 8950464 4253056
22:22:02 80209 8192000000 10925510880 11394654208 1937091968 19.124 97 25 51 0 1955604720 10594704 7918048
22:23:34 76240 8192000000 10924540448 11398557696 1965841424 19.352 99 18 36 1 1989160848 18091360 5228064
22:25:42 54752 8192000000 10867056960 11341467648 1910231712 18.909 98 19 38 1 1937289536 21694160 5363664
22:26:42 50775 8192000000 8967685984 9146761216 124712448 1.499 7 3 6 0 126555872 1238736 604688

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 26-02-2021 22:28:29 to 26-02-2021 22:29:01.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 90 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 26-02-2021 22:29:02 to 26-02-2021 22:29:03.

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          228937
MON$OLDEST_ACTIVE               228938
MON$OLDEST_SNAPSHOT             228938
MON$NEXT_TRANSACTION            228938
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                       1994176
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.33420 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.8.33420 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.8.33420 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.8.33420 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 ---
--- end of diff output ---

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

26.02.21 22:29:04. 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-26 22:29:07 No severe PSQL-related problems occured
26.02.21 22:29:08. End of report.