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

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 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 17498236 kB
MemAvailable 31413824 kB
Buffers 0 kB
Cached 14228496 kB
SwapCached 4864 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

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


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-01-08 16:27:13
DTS_END                         2021-01-08 16:27:13.2720
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/45602
TRN_ID                          239988
ATT_ID                          664
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: 9168.06 17376 1100167
customer order: creation 173.68 365 20841
customer order: refuse 14.60 331 1752
order to supplier: creation 46.61 1353 5593
order to supplier: removal 3.61 93266 433
invoice (draft): creation 46.60 3395 5592
invoice (draft): removal 51.99 780 6239
invoice accept: apply 42.40 18634 5088
invoice accept: cancel 46.60 795 5592
customer reserve: creation 3875.35 186 465042
customer reserve: removal 4566.41 57 547969
realization accept: apply 84.83 195 10180
realization accept: cancel 82.89 109 9947
payment from customer: creation 61.73 150 7408
payment from customer: removal 6.10 85 732
payment to supplier: creation 48.14 183 5777
payment to supplier: removal 3.78 74 453
service: total inventory turnovers 4.98 1118 598
service: total monetary turnovers 6.98 37 837
service: aggregate perf. data 0.75 26160 90
service: refresh index statistics 0.03 200254 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 08-01-2021 16:29:52 to 08-01-2021 16:29:54.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 8117
TEST_TIME 2 7176
TEST_TIME 3 7404
TEST_TIME 4 7093
TEST_TIME 5 6930
TEST_TIME 6 6332
TEST_TIME 7 6735
TEST_TIME 8 6609
TEST_TIME 9 6729
TEST_TIME 10 6468
TEST_TIME 11 6629
TEST_TIME 12 6523
TEST_TIME 13 6689
TEST_TIME 14 6744
TEST_TIME 15 6795
TEST_TIME 16 6791
TEST_TIME 17 6766
TEST_TIME 18 7191
TEST_TIME 19 7419
TEST_TIME 20 7434
TEST_TIME 21 7700
TEST_TIME 22 8215
TEST_TIME 23 8429
TEST_TIME 24 8476
TEST_TIME 25 8633
TEST_TIME 26 8681
TEST_TIME 27 9118
TEST_TIME 28 10042
TEST_TIME 29 10617
TEST_TIME 30 10519
TEST_TIME 31 10336
TEST_TIME 32 10390
TEST_TIME 33 10620
TEST_TIME 34 10490
TEST_TIME 35 10297
TEST_TIME 36 10078
TEST_TIME 37 9977
TEST_TIME 38 9859
TEST_TIME 39 10045
TEST_TIME 40 9889
TEST_TIME 41 9768
TEST_TIME 42 9819
TEST_TIME 43 9721
TEST_TIME 44 9698
TEST_TIME 45 9658
TEST_TIME 46 9590
TEST_TIME 47 9483
TEST_TIME 48 9514
TEST_TIME 49 9501
TEST_TIME 50 9441
TEST_TIME 51 9427
TEST_TIME 52 9309
TEST_TIME 53 9199
TEST_TIME 54 9297
TEST_TIME 55 9286
TEST_TIME 56 9244
TEST_TIME 57 9275
TEST_TIME 58 9221
TEST_TIME 59 9329
TEST_TIME 60 9382
TEST_TIME 61 9375
TEST_TIME 62 9373
TEST_TIME 63 9389
TEST_TIME 64 9371
TEST_TIME 65 9487
TEST_TIME 66 9542
TEST_TIME 67 9524
TEST_TIME 68 9555
TEST_TIME 69 9531
TEST_TIME 70 9407
TEST_TIME 71 9453
TEST_TIME 72 9405
TEST_TIME 73 9356
TEST_TIME 74 9353
TEST_TIME 75 9289
TEST_TIME 76 9318
TEST_TIME 77 9320
TEST_TIME 78 9237
TEST_TIME 79 9255
TEST_TIME 80 9236
TEST_TIME 81 9217
TEST_TIME 82 9267
TEST_TIME 83 9367
TEST_TIME 84 9328
TEST_TIME 85 9352
TEST_TIME 86 9361
TEST_TIME 87 9397
TEST_TIME 88 9339
TEST_TIME 89 9393
TEST_TIME 90 9423
TEST_TIME 91 9415
TEST_TIME 92 9386
TEST_TIME 93 9316
TEST_TIME 94 9274
TEST_TIME 95 9221
TEST_TIME 96 9236
TEST_TIME 97 9206
TEST_TIME 98 9195
TEST_TIME 99 9144
TEST_TIME 100 9141
TEST_TIME 101 9100
TEST_TIME 102 9065
TEST_TIME 103 9055
TEST_TIME 104 9055
TEST_TIME 105 9071
TEST_TIME 106 9173
TEST_TIME 107 9165
TEST_TIME 108 9196
TEST_TIME 109 9193
TEST_TIME 110 9179
TEST_TIME 111 9156
TEST_TIME 112 9205
TEST_TIME 113 9270
TEST_TIME 114 9292
TEST_TIME 115 9298
TEST_TIME 116 9236
TEST_TIME 117 9214
TEST_TIME 118 9178
TEST_TIME 119 9188
TEST_TIME 120 9171

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 08-01-2021 16:29:55 to 08-01-2021 16:29:59.

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 1530937 1530937 0 0.00 0 17547 7 0 0
doc_list_biud 1530936 1530936 0 0.00 0 89854 26 0 0
sp_add_invoice_to_stock 5186 5088 98 1.88 28 201107 18634 0 98
sp_cancel_adding_invoice 5592 5592 0 0.00 4 67949 795 0 0
sp_cancel_client_order 1752 1752 0 0.00 4 7538 331 0 0
sp_cancel_customer_reserve 547969 547969 0 0.00 1 38308 58 0 0
sp_cancel_pay_from_customer 732 732 0 0.00 2 5452 85 0 0
sp_cancel_pay_to_supplier 453 453 0 0.00 3 3649 75 0 0
sp_cancel_supplier_invoice 6244 6239 5 0.08 1 89863 781 0 5
sp_cancel_supplier_order 433 433 0 0.00 8 1152491 93267 0 0
sp_cancel_write_off 9947 9947 0 0.00 1 13658 110 0 0
sp_client_order 20841 20841 0 0.00 4 27231 366 0 0
sp_customer_reserve 465042 465042 0 0.00 0 51114 186 0 0
sp_fill_shopping_cart 32017 32017 0 0.00 1 13722 36 0 0
sp_fill_shopping_cart_clo_res 465038 465038 0 0.00 0 12706 13 0 0
sp_get_clo_for_invoice 5083 5083 0 0.00 0 33185 288 0 0
sp_kill_cost_storno 16724 16724 0 0.00 0 8873 60 0 0
sp_kill_qstorno_ret_qs2qd 1112557 1112557 0 0.00 0 89851 31 0 0
sp_kill_qty_storno 587192 587192 0 0.00 0 89852 68 0 0
sp_lock_selected_doc 21235 21235 0 0.00 0 7595 6 0 0
sp_make_cost_storno 28445 28445 0 0.00 0 17541 68 0 0
sp_multiply_rows_for_pdistr 28445 28445 0 0.00 0 8578 33 0 0
sp_multiply_rows_for_qdistr 20841 20841 0 0.00 0 14883 141 0 0
sp_pay_from_customer 7408 7408 0 0.00 4 21154 150 0 0
sp_pay_to_supplier 5777 5777 0 0.00 5 26030 183 0 0
sp_payment_common 13185 13185 0 0.00 1 11609 44 0 0
sp_qd_handle_on_cancel_clo 1752 1752 0 0.00 0 7529 292 0 0
sp_qd_handle_on_invoice_upd_sts 10672 10672 0 0.00 0 36307 337 0 0
sp_qd_handle_on_reserve_upd_sts 10180 10180 0 0.00 0 13637 62 0 0
sp_reserve_write_off 10180 10180 0 0.00 7 20900 195 0 0
sp_supplier_invoice 5592 5592 0 0.00 6 86259 3395 0 0
sp_supplier_order 5593 5593 0 0.00 5 29505 1353 0 0
srv_aggregate_perf_data 90 90 0 0.00 2613 594548 26160 0 0
srv_fill_mon_cache_memory 160 160 0 0.00 1166 126575 32114 0 0
srv_find_qd_qs_mism 1051885 1051885 0 0.00 0 16389 6 0 0
srv_make_invnt_saldo 598 598 0 0.00 31 31108 1119 0 0
srv_make_money_saldo 837 837 0 0.00 0 7942 37 0 0
srv_recalc_idx_stat 4 4 0 0.00 112570 355767 200254 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 5088 5088 0 0.00 0 38648 257 0 0
t$perf-norm:sp_cancel_adding_invoice 417 417 0 0.00 0 7617 118 0 0
t$perf-norm:sp_cancel_client_order 1752 1752 0 0.00 0 3059 16 0 0
t$perf-norm:sp_cancel_customer_reserve 733 733 0 0.00 0 5358 26 0 0
t$perf-norm:sp_cancel_pay_from_customer 732 732 0 0.00 0 573 3 0 0
t$perf-norm:sp_cancel_pay_to_supplier 453 453 0 0.00 0 905 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 400 400 0 0.00 0 4494 35 0 0
t$perf-norm:sp_cancel_supplier_order 433 433 0 0.00 0 38115 1596 0 0
t$perf-norm:sp_cancel_write_off 1055 1055 0 0.00 0 1603 9 0 0
t$perf-norm:sp_client_order 20841 20841 0 0.00 0 29147 25 0 0
t$perf-norm:sp_customer_reserve 1006 1006 0 0.00 0 27087 34 0 0
t$perf-norm:sp_pay_from_customer 7408 7408 0 0.00 0 28743 14 0 0
t$perf-norm:sp_pay_to_supplier 5777 5777 0 0.00 0 8377 12 0 0
t$perf-norm:sp_reserve_write_off 10180 10180 0 0.00 0 26767 16 0 0
t$perf-norm:sp_supplier_invoice 5592 5592 0 0.00 0 17626 28 0 0
t$perf-norm:sp_supplier_order 5593 5593 0 0.00 0 29154 25 0 0
t$perf-norm:srv_aggregate_perf_data 90 90 0 0.00 0 45 1 0 0
t$perf-norm:srv_fill_mon_cache_memory 160 160 0 0.00 0 678 17 0 0
t$perf-norm:srv_make_invnt_saldo 598 598 0 0.00 0 12039 41 0 0
t$perf-norm:srv_make_money_saldo 837 837 0 0.00 0 1687 12 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 6 3 0 0
v_add_invoice_to_stock 10356 10160 196 1.89 0 21108 21 0 196
v_all_customers 38172 38172 0 0.00 0 17 1 0 0
v_all_suppliers 30900 30900 0 0.00 0 14 1 0 0
v_all_wares 41682 41682 0 0.00 0 34 1 0 0
v_cancel_adding_invoice 834 834 0 0.00 0 2540 12 0 0
v_cancel_client_order 3504 3504 0 0.00 0 3616 11 0 0
v_cancel_customer_prepayment 1464 1464 0 0.00 0 611 4 0 0
v_cancel_customer_reserve 1466 1466 0 0.00 0 2425 6 0 0
v_cancel_payment_to_supplier 906 906 0 0.00 0 3564 11 0 0
v_cancel_supplier_invoice 810 800 10 1.23 0 622 12 0 10
v_cancel_supplier_order 866 866 0 0.00 0 3248 11 0 0
v_cancel_write_off 2110 2110 0 0.00 0 13365 20 0 0
v_max_id_clo_ord 5590 5590 0 0.00 0 3336 2 0 0
v_max_id_clo_res 1006 1006 0 0.00 0 2584 13 0 0
v_max_id_ord_sup 5586 5586 0 0.00 0 3534 3 0 0
v_max_non_paid_invoice 1503 1503 0 0.00 0 6193 17 0 0
v_max_non_paid_realizn 3982 3982 0 0.00 0 6191 7 0 0
v_min_id_clo_ord 5590 5590 0 0.00 0 3189 7 0 0
v_min_id_clo_res 1006 1006 0 0.00 0 2278 7 0 0
v_min_id_ord_sup 5586 5586 0 0.00 0 4739 4 0 0
v_min_non_paid_invoice 5777 5777 0 0.00 0 10893 31 0 0
v_min_non_paid_realizn 7408 7408 0 0.00 0 11585 31 0 0
v_our_firm 10362 10362 0 0.00 0 14 1 0 0
v_reserve_write_off 20360 20360 0 0.00 0 20853 9 0 0
x_lock_depdocs_on_canc_invoice 11431 11431 0 0.00 0 16377 114 0 0
x_lock_depdocs_on_canc_sup_ord 433 433 0 0.00 0 12479 351 0 0
x_make_qstorno_1000_1200 5593 5593 0 0.00 1 29471 1267 0 0
x_make_qstorno_1200_2000 5592 5592 0 0.00 3 77320 3273 0 0
x_make_qstorno_2100_3300 465042 465042 0 0.00 0 51112 171 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 08-01-2021 16:30:00 to 08-01-2021 16:30:04.

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
13:57:16 2 8192000000 8798422544 8808923136 5084640 0.062 1 1 2 0 5202688 55488 62560
13:57:22 9737 8192000000 10182189520 10477412352 810832912 9.006 67 37 77 0 824576800 2168944 11574944
13:57:39 31398 8192000000 10315854448 10629378048 1362531056 14.260 100 86 172 0 1395283888 4387488 28365344
13:58:21 32743 8192000000 10366454928 10688212992 1414760432 14.726 100 84 168 0 1448592800 6209104 27623264
13:59:08 22804 8192000000 10400538080 10724667392 1445779776 15.001 100 87 174 0 1481344512 7122352 28442384
13:59:41 12598 8192000000 10408980960 10739204096 1474744976 15.255 100 86 172 0 1510100208 7812896 27542336
14:00:07 15995 8192000000 10443146048 10774671360 1495164736 15.434 100 83 166 1 1530377744 8630752 26582256
14:00:36 15501 8192000000 10467843056 10803253248 1515611200 15.612 100 87 174 0 1552047008 9225952 27209856
14:01:07 14585 8192000000 10486520816 10827436032 1536048144 15.789 100 86 172 0 1572903792 9873120 26982528
14:01:28 23068 8192000000 10510820848 10855436288 1562816512 16.020 100 87 174 2 1600589008 10598672 27173824
14:01:59 17384 8192000000 10525974704 10879332352 1585362288 16.214 100 81 162 1 1621156320 10656096 25137936
14:02:28 18546 8192000000 10551010864 10907533312 1612690384 16.448 100 75 150 1 1645865136 10579248 22595504
14:02:59 13276 8192000000 10576493872 10937716736 1633832464 16.627 100 70 140 0 1664991616 10780256 20378896
14:03:23 9231 8192000000 10603835216 10965663744 1661020992 16.857 100 83 166 0 1697656016 12158608 24476416
14:03:44 9783 8192000000 10623681456 10992787456 1681465264 17.030 100 79 156 4 1717600480 12776304 23358912
14:04:07 9306 8192000000 10657609488 11029594112 1712283056 17.288 100 83 166 0 1749195440 12766064 24146320
14:04:24 10892 8192000000 10662853600 11036332032 1723337584 17.380 100 80 158 3 1759339568 13416608 22585376
14:04:47 6621 8192000000 10679528880 11055525888 1738762528 17.508 100 75 150 0 1771892032 11987520 21141984
14:05:00 10597 8192000000 10690126624 11064745984 1751232208 17.612 100 78 158 1 1785166160 11965152 21968800
14:05:19 5862 8192000000 10690287760 11076149248 1758619952 17.673 100 73 146 3 1792352096 13086000 20646144
14:05:32 3966 8192000000 10711800512 11094884352 1774730096 17.806 100 82 164 2 1809522752 11900288 22892368
14:05:43 4727 8192000000 10720485920 11103469568 1777899168 17.832 100 70 141 0 1809732768 11373168 20460432
14:05:56 4571 8192000000 10722886336 11111915520 1786707216 17.905 100 74 148 1 1820795888 12192176 21896496
14:06:07 12979 8192000000 10720567296 11114901504 1801561920 18.027 100 74 149 0 1832886080 9993488 21330672
14:06:27 4108 8192000000 10744524288 11131179008 1802529664 18.035 100 74 147 1 1834291632 11007296 20754672
14:06:38 3096 8192000000 10759297664 11144364032 1822872768 18.201 100 82 162 1 1856779712 11275872 22631072
14:06:47 3202 8192000000 10756611264 11152416768 1828769184 18.249 100 80 160 1 1863374096 11978256 22626656
14:06:57 2797 8192000000 10777783056 11166408704 1835684016 18.306 100 82 161 0 1869002304 10771040 22547248
14:07:07 4310 8192000000 10784343136 11168043008 1841075456 18.350 100 88 175 1 1878134080 12640336 24418288
14:07:17 3441 8192000000 10784310832 11171647488 1845103344 18.382 100 80 160 1 1880266992 12934736 22228912
14:07:27 2889 8192000000 10786984656 11173847040 1848275792 18.408 100 90 179 0 1887162000 14035536 24850672
14:07:36 1566 8192000000 10799319968 11185426432 1850730368 18.428 100 92 185 1 1890135328 14056256 25348704
14:07:44 1442 8192000000 10799234144 11184439296 1854225872 18.456 100 95 190 1 1894939104 13643024 27070208
14:07:53 2504 8192000000 10800689232 11190243328 1860010544 18.503 100 94 188 0 1900576848 13606896 26959408
14:08:01 2208 8192000000 10802745952 11191115776 1868274208 18.570 100 95 185 2 1907090208 12781888 26034112
14:08:10 2255 8192000000 10814853312 11202359296 1865600080 18.549 100 93 186 2 1906559248 15198352 25760816
14:08:18 1645 8192000000 10812043664 11201335296 1868309328 18.571 100 96 192 1 1908372176 13796384 26266464
14:08:26 1811 8192000000 10812814704 11200667648 1867904208 18.567 100 91 182 0 1907380128 13500992 25974928
14:08:35 1215 8192000000 10818327616 11206672384 1871428864 18.596 100 97 194 0 1913165008 14823888 26912256
14:08:42 1656 8192000000 10813831184 11207143424 1870817584 18.591 100 83 164 1 1908393456 13343392 24232480
14:08:50 19632 8192000000 10804017472 11203260416 1873063072 18.609 100 76 150 0 1904530960 10145376 21322512
14:09:16 8815 8192000000 10818333456 11211816960 1876542192 18.637 100 82 164 0 1910845872 9743600 24560080
14:09:32 2324 8192000000 10818307376 11218890752 1879116032 18.658 100 76 152 0 1912204816 11838880 21249904
14:09:43 3208 8192000000 10793353616 11213139968 1875883216 18.632 100 55 110 1 1902225696 11266112 15076368
14:09:53 3774 8192000000 10802189104 11214553088 1880174336 18.667 100 45 91 1 1901231024 8198240 12858448
14:10:05 2296 8192000000 10807164336 11218878464 1882641216 18.686 100 58 112 3 1908675120 10449728 15584176
14:10:14 5006 8192000000 10797219152 11217502208 1883047760 18.690 100 55 110 0 1910054544 11687984 15318800
14:10:27 6346 8192000000 10785621584 11214962688 1882837600 18.688 100 43 86 1 1903062240 7843840 12380800
14:10:42 60793 8192000000 10808994160 11226415104 1884595904 18.702 100 33 66 1 1900802640 5663088 10543648
14:11:49 9277 8192000000 10799139008 11236745216 1890223744 18.748 100 36 72 0 1909475376 9382688 9868944
14:12:05 4940 8192000000 10808525120 11236265984 1889826144 18.744 100 35 70 1 1905887520 6377632 9683744
14:12:19 5401 8192000000 10809279008 11243122688 1892704928 18.768 100 41 82 2 1917073072 12444208 11923936
14:12:33 9918 8192000000 10802076784 11234603008 1890241664 18.748 100 23 45 0 1902411216 5558576 6610976
14:12:49 4241 8192000000 10800257968 11237048320 1894978816 18.786 100 35 70 1 1911762384 7007440 9776128
14:13:05 5678 8192000000 10806105280 11238809600 1895357904 18.789 100 29 57 1 1910625616 6073968 9193744
14:13:20 6970 8192000000 10811554736 11245875200 1897075216 18.803 100 25 48 3 1911789088 6839360 7874512
14:13:37 8793 8192000000 10808617888 11246329856 1898422960 18.814 100 19 38 0 1910373488 6543424 5407104
14:13:52 6381 8192000000 10816620624 11248062464 1900581664 18.831 100 26 50 3 1912809200 5669552 6557984
14:14:05 5581 8192000000 10820970688 11250196480 1902811936 18.849 100 27 53 2 1917612208 6470352 8329920
14:14:16 15434 8192000000 10816639792 11251073024 1905036400 18.867 100 21 42 2 1917001936 5471888 6493648
14:14:40 11168 8192000000 10823795008 11257282560 1902639616 18.848 100 21 40 1 1914614000 6322160 5652224
14:14:58 14431 8192000000 10806256272 11244163072 1871700512 18.598 98 20 40 1 1882289440 5057328 5531600
14:15:18 62665 8192000000 10812249328 11259342848 1910768640 18.913 100 34 69 2 1926395872 6041776 9585456
14:16:27 5983 8192000000 10827587264 11261509632 1915900992 18.954 100 26 52 0 1933937616 10486624 7550000
14:16:43 7494 8192000000 10817817872 11252150272 1894570992 18.783 99 20 38 1 1909523744 9638432 5314320
14:16:58 5914 8192000000 10812647376 11245690880 1854744576 18.461 97 30 60 1 1869737168 6920944 8071648
14:17:10 7360 8192000000 10813837872 11248766976 1883281152 18.692 99 40 81 3 1901398672 6945136 11172384
14:17:25 4475 8192000000 10832908240 11254550528 1901798432 18.841 100 40 83 0 1919000480 5014816 12187232
14:17:37 7658 8192000000 10813463728 11248484352 1883512416 18.693 99 22 44 0 1900694064 11202800 5978848
14:17:53 9972 8192000000 10804850560 11238445056 1864094656 18.536 98 18 36 0 1874820144 5132688 5592800
14:18:10 9391 8192000000 10792812032 11220123648 1820002880 18.178 96 19 37 1 1830740464 5748624 4988960
14:18:28 6424 8192000000 10755809760 11187613696 1814012896 18.129 97 24 49 0 1827440096 5788736 7638464
14:18:41 13935 8192000000 10703257952 11118612480 1690249728 17.103 91 16 32 1 1700740272 5477264 5013280
14:19:05 11197 8192000000 10705813216 11114790912 1702947728 17.210 94 24 46 0 1714974560 4650624 7376208
14:19:22 8216 8192000000 10711771568 11118231552 1733477120 17.464 96 35 70 1 1749262976 5094464 10691392
14:19:38 15865 8192000000 10688511536 11106484224 1673931632 16.966 93 30 60 1 1688337312 5448032 8957648
14:20:00 62813 8192000000 10656000064 11074351104 1646683488 16.736 92 17 34 0 1656472032 5028384 4760160
14:21:14 10342 8192000000 10696962960 11106582528 1768459664 17.754 99 23 46 1 1781108544 5604128 7044752
14:21:32 7585 8192000000 10708687456 11130585088 1796464496 17.985 100 37 74 2 1815201056 8408768 10327792
14:21:48 7454 8192000000 10719463984 11123687424 1774630352 17.805 98 29 58 0 1788801584 5827168 8344064
14:22:05 9514 8192000000 10696474944 11116392448 1727259856 17.413 96 23 47 1 1738698400 4886000 6552544
14:22:22 4971 8192000000 10736671408 11145228288 1813522176 18.125 100 45 92 2 1833349616 6945296 12882144
14:22:38 4914 8192000000 10733272240 11145461760 1812610896 18.117 100 20 39 0 1823254576 5398432 5245248
14:22:53 9887 8192000000 10747900864 11161362432 1806108976 18.064 99 24 48 0 1818875616 5223472 7543168
14:23:13 9508 8192000000 10746012176 11158908928 1791732576 17.946 98 16 33 2 1806278432 9772080 4773776
14:23:29 7692 8192000000 10749735120 11162615808 1809434944 18.091 99 31 62 1 1823971504 4640752 9895808
14:23:44 9703 8192000000 10755670704 11173195776 1834202064 18.294 100 28 56 1 1848977520 5082992 9692464
14:24:00 6244 8192000000 10753156240 11171532800 1820876400 18.185 99 28 56 1 1835286000 6069040 8340560
14:24:13 11368 8192000000 10766007504 11175567360 1838154960 18.326 100 21 42 2 1849335248 5480656 5699632
14:24:31 34249 8192000000 10758630720 11186466816 1847057776 18.398 100 32 64 0 1861741104 4859056 9824272
14:25:24 35411 8192000000 10750369984 11192262656 1853979248 18.454 100 37 74 1 1870073792 5422016 10672528
14:26:06 4831 8192000000 10762503872 11192541184 1854803440 18.461 100 20 40 1 1866037184 5126624 6107120
14:26:17 10228 8192000000 10760786672 11197267968 1856015712 18.471 100 21 42 1 1867948512 6128432 5804368
14:26:35 8112 8192000000 10784564912 11205664768 1859851888 18.502 100 39 75 2 1877865664 7106992 10906784
14:26:51 12113 8192000000 10786761616 11204685824 1861664528 18.517 100 23 46 1 1874100176 5853104 6582544
14:27:13 5733 8192000000 10816374976 11230236672 1885212464 18.707 100 44 86 2 1902955568 5086848 12656256
14:27:26 5558 8192000000 10831250480 11242999808 1898680592 18.816 100 50 94 1 1919737328 7199184 13857552
14:27:42 9117 8192000000 10841643584 11256254464 1904813152 18.865 100 53 106 0 1928448800 8730544 14905104
14:27:58 6888 8192000000 10842672944 11260833792 1910808384 18.913 100 53 106 0 1934659712 9333488 14517840
14:28:23 27534 8192000000 10840819616 11264262144 1897503248 18.806 99 47 92 3 1921133120 9030000 14599872
14:29:00 5157 8192000000 10864561696 11275460608 1918086336 18.972 100 56 113 1 1944598032 10113456 16398240
14:29:24 26468 8192000000 10866750304 11288395776 1927216976 19.045 100 51 102 0 1952858032 11341088 14299968
14:29:58 3674 8192000000 10872027232 11288375296 1930528032 19.071 100 60 120 1 1958889520 10957664 17403824
14:30:11 11181 8192000000 10871775840 11291430912 1934986864 19.107 100 65 130 1 1966072928 12674480 18411584
14:30:30 7368 8192000000 10876281328 11297669120 1936997728 19.123 100 55 109 1 1963061584 10794016 15269840
14:30:48 55440 8192000000 10865403200 11298938880 1940400432 19.150 100 52 104 0 1966435904 9747488 16287984
14:31:56 9457 8192000000 10868290992 11304902656 1943992000 19.179 100 36 71 3 1963490080 9205904 10292176
14:32:14 54437 8192000000 10881557408 11321053184 1946565744 19.199 100 35 66 1 1966453888 9729408 10158736
14:33:32 30466 8192000000 10899171696 11342995456 1962361456 19.325 100 38 76 1 1991317040 17082256 11873328
14:34:14 15832 8192000000 10895050848 11335348224 1947820912 19.209 99 30 59 0 1970786416 13976672 8988832
14:34:39 13627 8192000000 10917967072 11348332544 1972841216 19.408 100 46 90 1 2002112256 15757280 13513760
14:35:02 11048 8192000000 10916455392 11353763840 1977662080 19.446 100 55 111 2 2011976640 17828640 16485920
14:35:21 3632 8192000000 10937103344 11361955840 1982936448 19.488 100 56 112 1 2021855472 22194160 16724864
14:35:33 9449 8192000000 10934235168 11365261312 1986421152 19.516 100 63 122 2 2023717344 18884576 18411616
14:36:02 12242 8192000000 10927565760 11368996864 1987281376 19.522 100 45 90 1 2022085184 21317744 13486064
14:36:24 6836 8192000000 10936360208 11376840704 1992613440 19.564 100 50 100 0 2027750544 20319472 14817632
14:36:38 2822 8192000000 10957841968 11382771712 2001031968 19.631 100 74 148 1 2043445472 20690560 21722944
14:36:52 1163 8192000000 10960775872 11380903936 2001961552 19.638 100 73 144 1 2044896432 21608992 21325888
14:37:01 12077 8192000000 10947229120 11384414208 2003985328 19.654 100 63 125 2 2044918912 23277200 17656384
14:37:25 24928 8192000000 10949651760 11390500864 2002022448 19.639 100 48 96 1 2040139168 23924480 14192240
14:38:20 12800 8192000000 10952209904 11388203008 2000587440 19.627 100 48 95 0 2039512512 24860720 14064352
14:38:43 5236 8192000000 10945558448 11388432384 1999369728 19.618 100 58 115 1 2039258464 22989312 16899424
14:38:58 10716 8192000000 10941107760 11388874752 2002067552 19.639 100 43 86 2 2039187136 24070304 13049280
14:39:33 9046 8192000000 10955449360 11400212480 2011259232 19.711 100 48 94 0 2050010496 23807152 14944112
14:39:51 4341 8192000000 10958419872 11394949120 2007071488 19.678 100 58 115 1 2049464672 24606784 17786400
14:40:03 1880 8192000000 10972063392 11407192064 2016524848 19.753 100 68 136 1 2062828224 26438848 19864528
14:40:13 7994 8192000000 10966836160 11407036416 2015744960 19.747 100 72 140 1 2062338848 25558080 21035808
14:40:28 2648 8192000000 10972469840 11388874752 1985348144 19.507 99 86 168 1 2036930032 26873424 24708464
14:40:37 4499 8192000000 10953162000 11371352064 1975956640 19.433 99 73 144 1 2026552816 28645696 21950480
14:40:50 5249 8192000000 10953363504 11381116928 1989934384 19.543 100 63 122 1 2037676288 29967984 17773920
14:41:05 2465 8192000000 10948997168 11376644096 1976691312 19.438 99 67 133 1 2025018224 28925232 19401680
14:41:14 2276 8192000000 10954694224 11377963008 1986843408 19.519 100 69 136 1 2036609520 28855680 20910432
14:41:23 3562 8192000000 10931134032 11360792576 1975682976 19.431 100 72 142 2 2027149712 29312800 22153936
14:41:41 9887 8192000000 10931158256 11362729984 1957068000 19.283 99 53 106 0 2003593808 30182880 16342928
14:42:02 4324 8192000000 10955327568 11376947200 1989621616 19.541 100 80 160 2 2044480416 31430816 23427984
14:42:16 3562 8192000000 10961327712 11380011008 1987639328 19.525 100 78 154 1 2044803152 33524608 23639216
14:42:27 1847 8192000000 10950088272 11363958784 1957022384 19.282 98 85 170 0 2016136432 34075760 25038288
14:42:38 3984 8192000000 10971899856 11386462208 1991761280 19.558 100 80 160 0 2050311472 35106704 23443488
14:42:49 1213 8192000000 10962940960 11371577344 1981711088 19.478 100 93 183 1 2044090736 34968752 27410896
14:42:59 3837 8192000000 10948512176 11365597184 1971189152 19.395 100 76 152 0 2030499744 36066384 23244208
14:43:10 2116 8192000000 10929142976 11339956224 1927788000 19.049 98 85 168 3 1987825904 35328320 24709584
14:43:20 9288 8192000000 10911759152 11329232896 1932039136 19.083 99 73 147 1 1989384656 36253856 21091664
14:43:38 3856 8192000000 10937472304 11355090944 1960550000 19.310 100 80 156 0 2022425744 38113456 23762288
14:43:52 2566 8192000000 10950755184 11368730624 1975431136 19.429 100 74 147 2 2036702048 38875008 22395904
14:44:03 9320 8192000000 10953597184 11377745920 1979650720 19.462 100 64 127 3 2038596448 39394528 19551200
14:44:25 2572 8192000000 10956994912 11373629440 1975165952 19.426 100 75 149 2 2040932992 42991152 22775888
14:44:34 4502 8192000000 10911232304 11318284288 1919301952 18.981 98 76 152 1 1989256160 46779008 23175200
14:44:47 5664 8192000000 10920572544 11333378048 1902165408 18.844 97 73 146 0 1972264784 46987632 23111744
14:45:03 1303 8192000000 10944138288 11346378752 1932881632 19.090 99 91 182 1 2012818896 50954640 28982624
14:45:13 1560 8192000000 10953597344 11360202752 1956687904 19.280 100 80 156 0 2033547616 52739360 24120352
14:45:23 4488 8192000000 10946492272 11359936512 1951217200 19.236 100 78 156 1 2029663504 53341232 25105072
14:45:36 7985 8192000000 10926878528 11349962752 1928726240 19.057 99 62 122 0 2002525472 54025680 19773552
14:45:52 5394 8192000000 10925029792 11347578880 1948041200 19.211 100 50 100 1 2010828656 46179232 16608224
14:46:08 4609 8192000000 10937633936 11345600512 1942419216 19.166 99 77 152 5 2012121216 45285344 24416656
14:46:22 2091 8192000000 10945930608 11353280512 1940752912 19.153 99 83 164 1 2013015952 46770768 25492272
14:46:32 2280 8192000000 10932302320 11337904128 1940114272 19.148 99 85 170 1 2015189056 47968624 27106160
14:46:43 3215 8192000000 10935405184 11342774272 1903253728 18.852 98 88 176 5 1978751760 47496336 28001696
14:46:53 2426 8192000000 10925644640 11328339968 1935006880 19.107 100 78 153 0 2005520736 46146208 24367648
14:47:04 3462 8192000000 10938189648 11344932864 1948456752 19.214 100 75 150 1 2017315792 45894384 22964656
14:47:16 3989 8192000000 10966641280 11369041920 1965562928 19.350 100 87 174 2 2039203648 46479520 27161200
14:47:29 2788 8192000000 10971240736 11378610176 1972683680 19.407 100 89 178 2 2050862704 50224480 27954544
14:47:39 1583 8192000000 10977939152 11385638912 1980746080 19.471 100 80 161 0 2058642128 51771552 26124496
14:47:48 4317 8192000000 10986985120 11392475136 1987747520 19.526 100 92 184 0 2070205408 53110160 29347728
14:47:59 1972 8192000000 10994406192 11401502720 1992665056 19.565 100 83 165 2 2071973792 53877968 25430768
14:48:10 2723 8192000000 10993235120 11406753792 1998431456 19.610 100 80 161 3 2078403200 55379968 24591776
14:48:21 2692 8192000000 11012591328 11420606464 2004973040 19.662 100 90 179 2 2089452208 55935888 28543280
14:48:32 1734 8192000000 11006798160 11421773824 2003064464 19.647 100 84 167 0 2087519248 58118272 26336512
14:48:40 1640 8192000000 11004287040 11420585984 1998436800 19.610 100 78 156 1 2082696608 59033712 25226096
14:48:50 4168 8192000000 10989997760 11413880832 1999022592 19.615 100 70 140 0 2076059600 54462112 22574896
14:49:06 19266 8192000000 10978847696 11418365952 1993731488 19.573 100 43 86 1 2066349824 57329312 15289024
14:49:39 5109 8192000000 10991408608 11425906688 1999419536 19.618 100 59 118 0 2079766208 59894608 20452064
14:49:54 22966 8192000000 10971854736 11411238912 1997121184 19.600 100 41 81 0 2064785408 53533968 14130256
14:50:49 27459 8192000000 10965469904 11411951616 1993244240 19.569 100 38 77 1 2050696480 44643792 12808448
14:51:27 4938 8192000000 10948537648 11381932032 1971862320 19.400 100 64 127 2 2037148816 45888768 19397728
14:51:47 5846 8192000000 10945442640 11379761152 1957242704 19.284 99 70 139 1 2024190592 45156288 21791600
14:52:05 23450 8192000000 10916062832 11366912000 1948520912 19.215 99 36 72 2 2002733408 42767424 11445072
14:52:59 14846 8192000000 10926149840 11391942656 1956391008 19.277 100 21 42 0 2012145168 47975952 7778208
14:54:32 13443 8192000000 10904550848 11361181696 1917212592 18.965 100 20 41 1 1989292832 63845440 8234800
14:54:56 2614 8192000000 10892946064 11356545024 1896276032 18.796 99 22 44 1 1966047568 61609648 8161888
14:55:19 18365 8192000000 10853592128 11317161984 1878201296 18.651 99 13 26 0 1926874784 44020016 4653472
14:55:47 41005 8192000000 10828548528 11290550272 1857292656 18.481 98 8 16 0 1888441152 28360656 2787840
14:56:34 74849 8192000000 10821563616 11274571776 1873030096 18.609 98 8 17 0 1886977248 11872384 2074768
14:57:55 70636 8192000000 10900667712 11333730304 1942111216 19.164 100 28 55 2 1959086432 9340064 7635152
14:59:17 30194 8192000000 10881597424 11347415040 1948244624 19.212 100 20 40 1 1967667728 14145200 5277904
14:59:53 102684 8192000000 10863642752 11335639040 1851700976 18.436 95 8 16 0 1877903392 24275584 1926832
15:01:42 95985 8192000000 10893120400 11332325376 1945563056 19.191 100 21 42 1 1970371008 18837136 5970816
15:03:25 93111 8192000000 10868084768 11331190784 1914354512 18.942 98 27 54 2 1934495440 12023728 8117200
15:05:19 68293 8192000000 10863203152 11350274048 1926343584 19.038 99 17 34 0 1947733856 16288416 5101856
15:06:49 43349 8192000000 10871680640 11327782912 1925216448 19.029 99 10 20 0 1942570720 14836992 2517280
15:07:39 61622 8192000000 10887958928 11350142976 1953030640 19.251 100 21 42 1 1971902336 12657104 6214592
15:08:47 38889 8192000000 10895395056 11360395264 1958383936 19.293 100 24 48 1 1983526464 17722912 7419616
15:09:42 58644 8192000000 10889489088 11351810048 1946960304 19.202 99 13 26 0 1964730384 14175952 3594128
15:11:44 23632 8192000000 10881102800 11351375872 1961392736 19.317 100 11 23 2 1974201872 9936368 2872768
15:12:22 103484 8192000000 10889582000 11357609984 1968092736 19.370 100 23 45 1 1987623136 12281952 7248448
15:14:19 31037 8192000000 10899635184 11351441408 1954778896 19.265 99 33 66 0 1971725936 7246880 9700160
15:14:57 66518 8192000000 10887871920 11368620032 1973013952 19.409 100 19 38 2 1989636784 11363200 5259632
15:16:10 62099 8192000000 10888714544 11366785024 1948955376 19.218 99 12 24 0 1967947984 15674192 3318416
15:17:19 41202 8192000000 10879556960 11365265408 1965941056 19.353 100 10 19 1 1984457920 15348832 3168032
15:18:06 55013 8192000000 10897275664 11378376704 1975821216 19.432 100 25 50 0 1994795840 12112112 6862512
15:19:11 44468 8192000000 10912090640 11388473344 1985488992 19.508 100 19 38 2 2004556928 13335776 5732160
15:20:29 71043 8192000000 10906918736 11401117696 1987951136 19.528 100 16 32 0 2003907648 11068160 4888352
15:22:11 73912 8192000000 10907867568 11386322944 1934039760 19.099 97 6 12 0 1948732240 12940736 1751744
15:23:34 54588 8192000000 10907543104 11381448704 1972891136 19.408 99 32 64 1 1991023424 9446032 8686256
15:24:38 46770 8192000000 10908269648 11372171264 1916601152 18.960 96 44 88 2 1942454560 13309904 12543504
15:25:33 61630 8192000000 10871324096 11353419776 1865206272 18.545 95 18 35 2 1881403376 11803472 4393632
15:26:42 69434 8192000000 10867656528 11322855424 1848234816 18.408 94 13 26 0 1862427392 10195456 3997120
15:28:04 78927 8192000000 10878986800 11330023424 1813087440 18.121 93 27 54 2 1829058096 7997696 7972960
15:29:38 34429 8192000000 10890780432 11355738112 1956868064 19.281 100 33 66 1 1976805456 11080112 8857280
15:30:27 51108 8192000000 10909295824 11365437440 1939046016 19.139 98 31 62 0 1958224480 10581664 8596800
15:31:25 40182 8192000000 10913780400 11385909248 1979328496 19.459 100 36 72 3 2006672160 16692160 10651504
15:32:14 126575 8192000000 10893716000 11362983936 1881344576 18.676 95 8 16 0 1899809408 16050608 2414224
15:34:38 70682 8192000000 10890101920 11361337344 1937779920 19.129 99 20 40 1 1962083760 18482464 5821376
15:35:55 53613 8192000000 10890899584 11353747456 1902647808 18.848 97 26 51 0 1921370144 11878544 6843792
15:38:34 83916 8192000000 10817470160 11289411584 1813069472 18.121 93 19 38 2 1834666496 15944432 5652592
15:40:06 36569 8192000000 10871428400 11322245120 1915050768 18.947 99 40 80 1 1940192288 13045328 12096192
15:40:59 64683 8192000000 10848062688 11319275520 1868923712 18.576 97 13 26 1 1885215248 12612704 3678832
15:42:10 56779 8192000000 10819618368 11285843968 1846843504 18.396 96 10 20 0 1866559568 16746784 2969280
15:43:14 48167 8192000000 10836244800 11296608256 1856871424 18.478 97 21 41 1 1875415568 12401920 6142224
15:44:09 80187 8192000000 10825127328 11297980416 1861622768 18.516 97 12 24 0 1877837008 12484544 3729696
15:46:59 49815 8192000000 10831630784 11294040064 1846696304 18.395 96 8 14 1 1860087088 11249552 2141232
15:47:55 52543 8192000000 10858478864 11325763584 1920653680 18.992 100 39 78 0 1947648624 15763712 11231232
15:48:54 54190 8192000000 10868337904 11329409024 1895731232 18.792 98 21 42 1 1914608496 12613888 6263376
15:49:54 67184 8192000000 10854314912 11322867712 1898295184 18.813 98 13 26 1 1914763696 12604864 3863648
15:51:08 32260 8192000000 10854029984 11296546816 1853448864 18.450 96 34 67 1 1870518256 7792736 9276656
15:51:47 30397 8192000000 10870305840 11318968320 1880979712 18.673 98 32 62 1 1903501168 14368752 8152704
15:52:29 35441 8192000000 10883248448 11324952576 1927603184 19.048 100 30 60 0 1945798000 9618096 8576720
15:53:10 12573 8192000000 10900738400 11336089600 1947182208 19.204 100 64 124 2 1975211280 10201808 17827264
15:53:32 27988 8192000000 10849765824 11307769856 1884742656 18.703 97 39 78 2 1906952464 11527504 10682304
15:54:06 60208 8192000000 10861775936 11326853120 1921794496 19.001 100 20 40 2 1938289808 11262304 5233008
15:55:13 52453 8192000000 10888862240 11337850880 1941342112 19.157 100 29 58 1 1959028912 9734768 7952032
15:56:16 44501 8192000000 10892004384 11352109056 1951217120 19.236 100 33 66 0 1974613024 13954672 9441232
15:57:17 81416 8192000000 10894893120 11354935296 1921055152 18.995 98 23 44 1 1937832000 11150992 5625856
15:58:45 122534 8192000000 10900437040 11353223168 1933145696 19.092 98 36 72 2 1952616768 9405296 10065776
16:00:56 85086 8192000000 10883273104 11352121344 1896254672 18.796 96 24 48 0 1912718048 9368144 7095232
16:02:28 50038 8192000000 10895100224 11363360768 1965837024 19.352 100 21 41 2 1979863856 8014736 6012096
16:03:24 87976 8192000000 10877145808 11355316224 1924048112 19.019 98 4 8 0 1935690000 10587232 1054656
16:04:58 71223 8192000000 10872301376 11346411520 1925115696 19.028 98 10 20 0 1936773904 9173616 2484592
16:07:05 64830 8192000000 10887659280 11366281216 1972972416 19.409 100 27 53 1 1989437648 8973696 7491536
16:08:30 47655 8192000000 10877135152 11359666176 1934001680 19.099 98 5 10 1 1942732656 7221072 1509904
16:09:24 34467 8192000000 10902066128 11367997440 1959127856 19.299 99 23 46 0 1973318032 7890016 6300160
16:10:13 46741 8192000000 10891495792 11370196992 1939457552 19.142 98 19 38 0 1955298496 10067568 5773376
16:11:06 36842 8192000000 10908256096 11361910784 1919790048 18.985 97 15 30 2 1937367472 13133376 4444048
16:12:04 70234 8192000000 10893258672 11377479680 1958942448 19.298 99 22 44 1 1979858080 14740512 6175120
16:13:23 53886 8192000000 10898985408 11371958272 1959794144 19.304 99 18 36 0 1978934320 14363344 4776832
16:14:24 33083 8192000000 10913733824 11380686848 1965842752 19.352 99 23 46 1 1982892688 10883680 6166256
16:15:03 58619 8192000000 10890848448 11361611776 1866400848 18.555 94 23 46 1 1886067968 13280064 6387056
16:16:11 50267 8192000000 10883897888 11346694144 1902631248 18.847 97 23 46 1 1920323824 11603168 6089408
16:17:12 28987 8192000000 10920500720 11354730496 1940686208 19.152 99 23 46 1 1954806960 8066640 6054112
16:17:48 25640 8192000000 10919542064 11366072320 1956640688 19.279 99 42 84 0 1978535376 9582480 12312208
16:18:51 67390 8192000000 10896522784 11369431040 1966790656 19.360 100 28 56 0 1990789536 16090336 7908544
16:20:21 65952 8192000000 10908583920 11393323008 1953343184 19.253 99 13 26 0 1973296960 16351920 3601856
16:21:33 59258 8192000000 10909296768 11359641600 1924079936 19.020 97 19 37 0 1938278272 8944496 5253840
16:22:45 69828 8192000000 10863725840 11339034624 1887622288 18.727 96 17 34 1 1901267216 8525184 5119744
16:24:28 89398 8192000000 10854254464 11314634752 1870547376 18.589 96 27 54 0 1887889168 9725920 7615872
16:26:05 69121 8192000000 9837200352 10218242048 957482096 10.464 49 8 16 0 967818448 7812448 2523904

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:32, from 08-01-2021 16:30:05 to 08-01-2021 16:30:37.

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:01, from 08-01-2021 16:30:38 to 08-01-2021 16:30:39.

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          240245
MON$OLDEST_ACTIVE               240246
MON$OLDEST_SNAPSHOT             240246
MON$NEXT_TRANSACTION            240246
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                       2009792
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

Database statistics

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

Database validation

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

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

--- start of diff output ---
:562: 
:563: mscs-test-161.budzdorov.ru    Fri Jan  8 16:27:17 2021
:564:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:565: 
:566: 
:567: mscs-test-161.budzdorov.ru    Fri Jan  8 16:27:49 2021
:568:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:569: 
:570: 
:571: mscs-test-161.budzdorov.ru    Fri Jan  8 16:28:04 2021
:572:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:573: 
--- end of diff output ---

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

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